WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

Question Posted / jabamit

4 Answers
9807 Views
CarrizalSoft Technologies, L&T, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / jabamit

CLUSTER INDEX BCZ THAT WORK PHYSICALLY(MEANS ALREADY IN DEC
OR ASC ORDER) BUT NON CLUSTER INDEX WORK DYNAMICALLY.

Is This Answer Correct ?

15 Yes

3 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / ashu_jsr

Cluster Index will be faster because data is already sorted
wrt to the index, hence you get the absolute position of
the data, where as in case of noncluster index the relative
position is given by the index

Is This Answer Correct ?

7 Yes

0 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / shaurabh thapa

Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.

Is This Answer Correct ?

10 Yes

8 No

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX..

Answer / g.ashok

Non clustered index is fast

Is This Answer Correct ?

1 Yes

3 No

Post New Answer