Q:

What is “index bloat”?

0

What is “index bloat”?


  1. Index filling up with keys.
  2. No-longer-needed keys in an index aren’t reclaimed, therefore increasing space required to store an index, as well as time it takes to scan.
  3. Indexing inefficiently, like choosing to index timestamps in a table.
  4. Indexing too many tables, resulting in inefficient database performance.

All Answers

need an explanation for this answer? contact us directly to get an explanation for this answer

Correct Answer:

B.No-longer-needed keys in an index aren’t reclaimed, therefore increasing space required to store an index, as well as time it takes to scan.

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

This question belongs to these collections

Similar questions


need a help?


find thousands of online teachers now