Menu
In SQL Server 2008, how many clustered indexes there can be in one table?
830
Clustered index structure overview SQL Server allows us to create only one Clustered index per each table, as the data can be sorted in the table using one order criteria. In the heap tables, the absence of the clustered index means that the data is not sorted in the underlying table.
A table can have only one clustered index. A table can have multiple non-clustered index.
SQL Server allows us to create multiple Non-clustered indexes, up to 999 Non-clustered indexes, on each table, with index IDs values assigned to each index starting from 2 for each partition used by the index, as you can find in the sys. partitions table.
A table or view is allowed one clustered index at a time. A view with a unique clustered index is called an indexed view.
Only one; and 999 non-clustered indexes http://msdn.microsoft.com/en-us/library/ms143432.aspx
165
One. As noted here:
"A clustered index determines the physical order of data in a table. A clustered index is analogous to a telephone directory, which arranges data by last name. Because the clustered index dictates the physical storage order of the data in the table, a table can contain only one clustered index."
21
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
