Which index type sorts and stores the data rows of the table or view in order based on the index key?

Options
- Clustered index
- Non clustered index
- Full-text


CORRECT ANSWER : Clustered index

Discussion Board
Clustered index

Clustered index sorts and stores the data rows of the table or view in order based on the index key. A clustered index can also be a unique index. You can create clustered indexes on tables by using SQL Server Management Studio or Transact-SQL. With few exceptions, every table should have a clustered index. Besides improving query performance, a clustered index can be rebuilt or reorganized on demand to control table fragmentation. A clustered index can also be created on a view. When you create a UNIQUE constraint, a unique non-clustered index is created to enforce a UNIQUE constraint by default. You can specify a unique clustered index if a clustered index on the table does not already exist.

Prajakta Pandit 03-8-2017 04:22 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement