Answer / manoj

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

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

Answer / chandra bhan singh

Three Type of indexes in sql

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

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

Answer / mohd zubair khan

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Answer / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

How can we delete a table in sql server?

0 Answers  

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

What are acid properties of transaction?

0 Answers  

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

What are the new security features added in sql server 2012? : sql server security

0 Answers  

How to stop a loop early with break statements in ms sql server?

0 Answers  

Difference between report and query parameter. Why do we need different type of parameter?

0 Answers  

Explain index in sql server?

0 Answers  

How real and float literal values are rounded?

0 Answers  

What are the different types of indexes?

0 Answers   Blue Star,

Tell me what is difference between view and materialized view?

0 Answers