In DB2, what is the purpose of clustering indexes?

  • Ensure referential integrity
  • Improve query performance
  • Organize data physically
  • Reduce storage space
Clustering indexes in DB2 serve the purpose of organizing data physically. They arrange table rows on disk in the same sequence as the index key columns, which helps in enhancing query performance by reducing disk I/O. This physical organization also benefits range retrieval operations, such as those found in join and sort operations. 
Add your answer
Loading...

Leave a comment

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