Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11293 Views
- CarrizalSoft Technologies, L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is tempdb database? : SQL Server Architecture
Tell me about the approaches which you used to counter the DI problems.
What is the difference between push and pull subscription? : sql server replication
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is the difference between function and stored procedure in sql server?
How to create a stored procedure with a statement block in ms sql server?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
How to populate a table in sql server?
What does it mean to normalize data?
What causes index fragmentation?
What does <> symbol mean?
What is a livelock?
Why is sql server log file full?
