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.
Loading...
Related Quiz
- Which of the following is a potential drawback of denormalization?
- What is the significance of the XML Declaration in DB2?
- What are the functions of the Database Services component within DB2's architecture?
- What advantages does XML provide over JSON in DB2?
- The DB2 event monitor captures information about ________.