Friday, February 10, 2012

clustered index

can we create clustered index on non primary keyTry to use SQL Books Online first:

Quote:

Originally Posted by SQL Books Online

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON <object> ( column [ ASC | DESC ] [ ,...n ] )
...

It means that index can be either clustered on non-clustered. Please note that there can be only one clustered index per table.

No comments:

Post a Comment