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

Share Our Frineds