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 is memory-optimized nonclustered indexes

957

Tell me what is de-normalization and what are some of the examples of it?

958

What is the difference between char and varchar2 datatype in sql?

1006

What is difference between rollback immediate and with no_wait during alter database?

1015

How many instances per computer are there in sql server 2000?

1009

List the advantages of using stored procedures?

997

What is dynamic cursor in SQL SERVER?

1001

Tell me about the approaches which you used to counter the DI problems.

1268

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1065

What is scheduled job and how to create it?

923

What are sp_configure commands and set commands?

957

What is the main purpose of having conversation group?

846

How to download and install the scaled-down database adventureworkslt?

952

Explain a join?

1003

What does normalization do to data?

989