The ________ index physically reorganizes the table data based on the indexed column(s).

  • Clustered
  • Composite
  • Non-clustered
  • Unique
A clustered index in DB2 physically reorganizes the table data based on the indexed column(s). It arranges the rows in the table in the order of the indexed column(s), resulting in the actual data storage reflecting the index structure. This can significantly improve the performance of queries involving range-based searches or sorting operations since the data retrieval is aligned with the physical order of the rows, reducing the need for extensive disk I/O operations. 
Add your answer
Loading...

Leave a comment

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