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