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 / rohti nanda

Answer Posted / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1970

Where do we use trace frag?

1023

What is default constraint in ms sql server?

1045

How to create percentile function?

156

Can you type more than one query in the query editor screen at the same time?

1011

How can I know what locks are running on which resource?

957

What are the different types of triggers in SQL SERVER?

1141

What are the advantages of passing name-value pairs as parameters?

1168

Define inner join? Explain with an example?

1003

What to perform pattern match with the like operator?

886

Which is faster statement or preparedstatement?

957

How to automatically create a log when an exception is being received into SQL Server?

1297

List some of the rules that apply to creating and using a ‘view’

888

what is checksum in sql server.........???

1691

Tell me what is a linked server?

1041