Saturday, 31 March 2012

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

No comments:

Post a Comment