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

What is optimization and its types?

983

Which tools are available to manage SQL Azure databases and servers?

115

What is acid mean in sql server?

1120

What is the recommended total size of your memory optimized tables?

966

Is it possible to have clustered index on separate drive from original table location?

967

Define the one-to-one relationship while designing tables.

903

How to drop an existing table with "drop table" statements in ms sql server?

1086

What is openxml in sql server?

1172

Why use view instead of a table?

953

Define compound operators?

916

What is the purpose of grouping data in a report?

968

Explain atomicity?

1060

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

Can we perform backup restore operation on tempdb? : sql server database administration

999

what is a live lock? : Sql server database administration

957