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