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

application server is slow what may be the problem

1785

Is there any difference between the primary key and unique key?

574

What are the aggregate and scalar functions?

527

Do you know what are the properties of the relational tables?

577

What are the advantages to use stored procedures?

573

What is resource governor?

552

what are triggers? : Sql server database administration

508

What are partitioned views and distributed partitioned views?

608

What are parameterized reports? What are cascading parameters in ssrs reports?

100

What is an execution plan? How would you view the execution plan?

551

What is SQL Azure Firewall?

116

What are the recovery models for a database?

620

How to defragment indexes with alter index ... Reorganize?

588

Can you move the resources after pausing the node? : sql server database administration

596

What is the contrast between sql and pl/sql?

626