What are the different index configurations a table can have?

A table can have one of the following index configurations:
  1. No indexes 
  2. A clustered index
  3. A clustered index and many nonclustered indexes
  4. A nonclustered index
  5. Many nonclustered indexes

Comments

Popular posts from this blog

Google to FTS Syntax Cheat Sheet

Reading lines from a file using SQL Server

Schema Binding and Indexed Views in SQL Server