How many types of indexes are there in SQL Server?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / abcd

6 Answers
10244 Views
CarrizalSoft Technologies, United Healthcare, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many types of indexes are there in SQL Server?..

Answer / manoj

As per MSDN there are 9 types:
http://msdn.microsoft.com/en-us/library/ms175049.aspx

Is This Answer Correct ?

6 Yes

0 No

How many types of indexes are there in SQL Server?..

Answer / abcd

9 indexes:

1. Clustered,
2. Non-clustered,
3. Unique,
4. Index with included columns,
5. Indexed views,
6. Full text,
7. Spatial,
8. Filtered &
9. XML

Is This Answer Correct ?

9 Yes

4 No

How many types of indexes are there in SQL Server?..

Answer / chandra bhan singh

Three Type of indexes in sql

1.Clustered
2.Non-clustered
2.Primary XML

Is This Answer Correct ?

3 Yes

1 No

How many types of indexes are there in SQL Server?..

Answer / b.hari kumar reddy

mainly five type of indexes in sql

1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index

Is This Answer Correct ?

0 Yes

0 No

How many types of indexes are there in SQL Server?..

Answer / mohd zubair khan

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Is This Answer Correct ?

6 Yes

7 No

How many types of indexes are there in SQL Server?..

Answer / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Is This Answer Correct ?

2 Yes

3 No

Post New Answer