Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating clustered index
Message
 
 
To
09/01/2010 19:41:21
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01442954
Message ID:
01442962
Views:
30
>>No. You can have only one clustered index per table.
>
>So, if I want to create a clustered index, I need to add clustered in it such as:
>
>
>CREATE CLUSTERED INDEX
>
>
>Or, when I want to create a clustered index, should I only ommit including it?

You need to explicitly specify CLUSTERED when you want to make the index CLUSTERED. By default it would be nonclustered.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform