SQL Server Table - index configuration possibilities
Mainly table can have 5 index configuration possibilities. These are- A table can have No indexes
- A table can have only one clustered index
- A table can have only one clustered index and many non-clustered indexes
- A table can have only one non-clustered index
- A table can have Many nonclustered indexes
This is one of the best interview question for DOTNET people.
Post a Comment
Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.