How many types of indexes are there in SQL Server?

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

More SQL Server Interview Questions

What is data compression?

0 Answers  


hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  


What is the difference between executequery () and executeupdate ()?

0 Answers  


Can foreign key be duplicate?

0 Answers  






Explain logical operators in sql server?

0 Answers  


How to recompile stored procedure at run time?

0 Answers  


What happens to a trigger with multiple affected rows?

0 Answers  


What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,


Explain the functionalities that views support?

0 Answers  


Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  


What are magic tables in sql server?

0 Answers  


Categories