WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
Answer Posted / 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 |
Post New Answer View All Answers
What is raid? : SQL Server Architecture
How to create hyperlink from returned sql query ?
Explain few examples of stored procedure over triggers?
Differentiate between a local and a global temporary table?
What are the 3 types of schema?
How do I find the port number for sql server?
What is the Main Difference between ACCESS and SQL SERVER?
Why should one not prefix user stored procedures with ‘sp_’?
When does a workload on SQL Azure get throttled?
How to use union to merge outputs from two queries together in ms sql server?
Explain table valued parameters in sql server? Why tvp used?
How do I partition a table in sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain difference between cross join and full outer join?
How do I find the sql server instance name?