What is index fragmentation and how does it affect query performance?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is index fragmentation and how does it affect query performance?

Key points

  • Index fragmentation results from disordered data pages in an index
  • Increased page reads and I/O impact query performance
  • REBUILD or REORGANIZE can address index fragmentation
  • Fragmentation does not refer to covering too many columns in an index

Ready to go further?

Start full exam Practice more questions

Related questions