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 is the difference between count and distinct count?

877

How many partitions a clustered index has by default in sql server 2012?

1081

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

888

How to create a new schema in a database?

1131

Relational calculus is what type of language?

1019

System requirements for sql server 2005 express edition?

1001

Explain few examples of stored procedure over triggers?

1021

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

1269

Explain what is the function of sql server agent windows service?

986

What do you mean by stored techniques? How would we use it?

1022

What is transaction server implicit?

993

What is the difference between a unique key and primary key?

936

How to restore performance issues and how to check?

1994

Why do we use non clustered index?

1067

What is the size of transaction log file?

917