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 do you understand by hotfixes and patches in sql server?

973

What are the types of sql server?

1042

How to write character string constants or literals in ms sql server?

1005

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

981

What is an sql server agent?

1053

What are the different types of collation sensitivity?

1106

What do you understand by replication in sql server?

1054

How to use subqueries with the in operators in ms sql server?

1063

What is advantage data architect?

911

What is partition in sql server?

1026

Explain how to use linked server?

983

Explain the usage of floor function in sql server.

953

What is constraints and its types?

935

What are the disadvantages of primary key and foreign key in SQL?

1101

Can we call future method from trigger?

928