Thursday, June 12, 2008

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

2 comments: