Posts

Showing posts with the label NonClustered Index

What are the different index configurations a table can have?

A table can have one of the following index configurations: No indexes  A clustered index A clustered index and many nonclustered indexes A nonclustered index Many nonclustered indexes