How many types of indices are there in sql server?


can any one tell me how many indexes are there in the SQL server?



There are two different types of indices in SQL server. They are:

Clustered Index: The clustered index are responsible for sorting and storing the rows data in the table or allows you to view the data based on the fundamentals.

Non - clustered index: A non-clustered index is the type of index that contains the non-clustered key values with each value having a pointer to the data row that is important.


If you want to unleash your potential in this competitive field, please visit the SQL course page for more information, where you can find the SQL tutorials and SQL frequently asked interview questions and answers as well.


This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.