mainly five type of indexes in sql 1.simple index 2.composite index 3.

How many types of indexes are there in SQL Server?

Question Posted / b.hari kumar reddy

Answer Posted / b.hari kumar reddy

mainly five type of indexes in sql

1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the differences between local and global temporary tables?

1072

Explain the properties of the relational tables?

988

What is sql server locking?

977

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

113

Explain features and concepts of analysis services?

965

Please differentiate between a local and a global temporary table?

997

Explain transaction server distributed transaction?

967

How to create a simple user defined function in ms sql server?

1008

Describe in brief authentication modes in sql server.

1020

What is a non-clustered index?

991

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1000

Describe different Processing Modes offered by SSRS?

248

How to add more data to the testing table in ms sql server?

1075

Are resultset updatable?

945

What is a file group?

1084