Three type of indexes in sql 1.Clustered 2.Non-clustered 3.Unique

How many types of indexes are there in SQL Server?

Question Posted / mohd zubair khan

Answer Posted / mohd zubair khan

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Is This Answer Correct ?

6 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What do you mean by data integrity?

1125

Where in ms sql server is ’100’ equal to ‘0’?

1130

How to call a function from a stored procedure in SQL Server ?

1081

How to modify existing triggers using "alter trigger"?

1064

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

176

What do you understand by replication in sql server?

1125

What is an identity?

1076

What will be the maximum number of indexes per table?

1016

What is 2nf normalization?

1087

What is abstracting periodical?

990

What are the types of resultset?

1012

What are the types of subquery?

1095

What is cte (common table expression)?

1085

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

1042

Is resultset an interface?

1037