There are basically two types of indexes that we use with the SQL Server.

What are the types of indexes available with SQL Server?

Question Posted / guest

Answer Posted / guest

There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.

Is This Answer Correct ?

12 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are drillthrough reports?

141

What is a non-clustered index?

949

What is instead of dml trigger?

946

What are sql server functions?

934

How many non clustered indexes there can be on table ?

860

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1200

What happens when converting big values to integers?

955

How to grant a permission in ms sql server using "grant execute" statements?

1022

How do we know if any query is retrieving a large amount of data or very little data?

916

What is the current limitation of the size of SQL Azure DB?

124

Explain about the command-line tool SQLCMD?

1017

how can you attach more than 20 ldf files in sql server

1946

What is use of except clause?

1036

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

913

How do you rebuild an identity column?

894