There are two types of indexs. 1. Cluster Index (Ex. Primary Key) 2. Non

About types of indexes in SQL server ?

Question Posted / pandian

Answer Posted / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to fine-tune reports?

266

What is sql server english query?

1109

Name some of the open source software that you can use in alternative to SSR?

159

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4369

Is truncate autocommit?

931

What is the difference between for xml raw and for xml auto?

1022

What are trace flags and mention a few common trace flags used with sql server?

1077

What is blocking and how would you troubleshoot it? : sql server database administration

1036

What does top operator do?

1008

How to get a list of all tables with "sys.tables" view in ms sql server?

1027

Explain what is lock escalation and what is its purpose?

923

What is SQL Azure Fabric?

110

How to generate create view script on an existing view?

976

What are the types of database schema? : sql server analysis services, ssas

1118

How is table type constraint applied to a table?

970