what is cluster and nin-cluster index?

Question Posted / guest

4 Answers
6045 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is cluster and nin-cluster index?..

Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Is This Answer Correct ?

9 Yes

0 No

what is cluster and nin-cluster index?..

Answer / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Is This Answer Correct ?

4 Yes

0 No

what is cluster and nin-cluster index?..

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Is This Answer Correct ?

5 Yes

2 No

what is cluster and nin-cluster index?..

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer