Sqlserver

Question

can we create a clustered and non cluster index on same column? can we create a cluster index on multiple columns? let me know any one have the answer for these two

jayachandra b · Answer

please write syntax for (cluster and nocluster) same colum?

Jignesh Trivedi · Answer

yes you can create cluster and non cluster index on same column. you can create only one cluster index per table so you can create cluster index on composite key. Let us know if you required any additional information.

Manas Mohapatra · Answer

Question1 : We can have two index(clustered and non-clustered index) on same column of table. Question2 : We can't have more than one clustered index on multiple columns in table. More info: For SQL Server 2005: 1 Clustered Index + 249 Nonclustered Index = 250 Index http://msdn.microsoft.com/en-us/library/ms143432(SQL.90).aspx For SQL Server 2008: 1 Clustered Index + 999 Nonclustered Index = 1000 Index http://msdn.microsoft.com/en-us/library/ms143432.aspx