9 indexes: 1. Clustered, 2. Non-clustered, 3. Unique, 4. Index with i

How many types of indexes are there in SQL Server?

Question Posted / abcd

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a hint?

934

How do I find information about the install locations for the various instances running on a computer?

1028

What is in place upgrade in sql server?

987

Explain acid?

1014

How to get all stored procedures in sql server?

936

Which tcl commands are available on the sql server?

1015

What is parameterized reports in ssrs ?

139

What do you mean by data manipulation language?

944

What are xml indexes?

886

Can you always create a cache of a report?

156

Which tools are available to manage SQL Azure databases and servers?

113

How to edit table in sql server 2017?

877

Do you know hot add cpu in sql server 2008?

894

Explain atomicity?

970

How to insert and update data into a table with "insert" and "update" statements?

914