Sqlserver

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

0

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.

0

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

0