Multiple choice technology databases

Which type of index is used to control the physical sequence of data in table?

  1. Partitioning Index

  2. Clustering Index

  3. Unique Index

  4. Non-partitioning Secondary Index
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A clustering index determines the physical order in which data rows are stored on disk. When a clustering index is defined, DB2 attempts to maintain the data sequence matching the index key order. Other index types (unique, partitioning, secondary) only affect logical access paths.

Keep practicing — related questions