When a query performance degrades due to an unoptimized index, this is often referred to as ________.

  • Index Bloat
  • Index Degradation
  • Index Fragmentation
  • Index Mismatch
Index Fragmentation occurs when the logical order of index pages does not match the physical order of the data pages. This can happen due to data modifications like insertions, updates, or deletions, causing the index to become fragmented and leading to degraded query performance. It's essential to regularly maintain indexes to prevent fragmentation and ensure optimal query execution.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *