WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Write a SQL queries on Self Join and Inner Join.
could u plz explain about joins and views?
Explain the creation and execution of a user-defined function in the sql server?
What is the disadvantages of index?
What is a transaction and what are ACID properties?
14 Answers Config Systems, IBM, TCS, Virtusa,
What is triggers in ms sql server?
How do you troubleshoot SQL Server if its running very slow?
Explain triggers?
What is difference in performance between insert top (n) into table and using top with insert?
What is the diff between Static Queries and Dynamic queries give me some examples
Explain the advantages of merge replication?
whats the maximum size of view state??