Discussion Board

Clustered index Yes, 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 nonclustered 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-6-2017 07:38 AM

Can a clustered index also be a unique index? If the clustered index is not a unique index, SQL Server makes any duplicate keys unique by adding an internally generated value called a uniqueifier. Therefore, yes, a cluster index can also be and must be a unique index. Ulises Reyes 01-28-2017 11:47 PM

Can a clustered index also be a unique index? Its False because unique index can contain one null value but clustered index no. Vijay Garg 11-29-2016 04:26 AM

Clustered Index can be a Unique Index If you create a primary key on a column, SQL by default will create Unidue Clustered Index on the column; Hence it is proved that Clustered Index can be a Unique Index Saravanakumar 10-9-2014 10:36 AM

i think ans wrong if we create clustered index on non primary key column and non unique column , then it wont behaviour like unique so correct ans is FALSE Ramana 09-29-2014 06:18 AM

Can a clustered index also be a unique index? Could you please explain in detail. kailash ameta 09-8-2014 04:02 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*