Index means to sort the data. Cluster index is physical order of the dat

diffrence between Cluster Index and non Cluster Index

Question Posted / kumar.t

Answer Posted / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What protocol does sql server use?

985

What is sql server agent and what are the two modes of authentication in sql server?

1107

How many full-text indexes can a table have?

1022

what is spatial nonclustered index

1032

tell me the disaster recovery plan

2558

You want to use a perspective in an mdx query. How do you select the perspective?

246

Is natural join and equi join same?

1026

what are the disadvantages of cursors? : Sql server database administration

1078

What are scalar functions in sql?

1202

What is efficiency data?

1002

Why it is recommended to avoid referencing a floating point column in the where clause?

1008

What are indexes in ms sql server?

1112

What do you understand by replication in sql server?

1124

What Are the Main Features of SQL Azure?

121

What is normalization? Explain its different types?

1149