not only two type, more type of indexes there such as Clustered Index with

What are the type of Indexes? which one is best, why?

Question Posted / a.ganesh

Answer Posted / a.ganesh

not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate between a primary key and a unique key.

1024

What are trace files?

914

How do you delete duplicate records in sql server?

1014

What is the difference between functions and stored procedures?

1111

What is a trigger in sql server?

1117

What is dknf in normalization form?

1006

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What is a cache in ssrs?

132

Explain triggers?

964

Explain how many normalization forms?

990

Can you explain what are commit and rollback in sql?

904

What is set nocount on and what is set nocount off?

900

What are the 2 types of classifications of constraints in the sql server?

1067

Does partitioning ssd reduce performance?

867

Can sql servers linked to other servers like oracle?

916