Multiple choice technology web technology

Which type of index physically orders the rows in a table?

  1. Unique Index

  2. Clustered Index

  3. Non-Clustered Index

  4. Foreign Key
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A clustered index physically sorts and stores the data rows in the table based on the index key. This means the table's actual data on disk is arranged in the order of the clustered index columns. Each table can have only one clustered index because the data can only be physically stored in one order. Non-clustered indexes create separate structures that point to the actual data.

Keep practicing — related questions