Different index configurations for SQL Server table
By Santhosh N
This explains the different index configurations a SQL Server table can have
Any typical SQL Server table can consist of these following index configurations:
1) Any number of non-clustered indexes (ofcourse limited to maximum of 999 in SQL
Server 2008 R2 and 249 in prior versions)
2) Single non-clustered index
3) Single clustered index and many non-clustered indexes
4) Single clustered index
5) No indexes at all
Related FAQs
This explains about using functions with Indexed columns in Sql query
This explains the best scenarios to create CLUSTERED index on the table in SQL Server.
This explains about the creation of NON-CLUSTERED indexes and maximum allowed.
Different index configurations for SQL Server table (1713 Views)