Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11471 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 are four major operators that can be used to combine conditions on a where clause?
Differentiate between truncate vs delete in mssql?
Why use “nolock” in sql server?
What sql server means?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is data compression? : sql server database administration
How dts is used to extract, transform and consolidate data?
What is triggers and stored procedures?
Explain try...catch with sql server?
What are the five characteristics of good data?
Explain the microsoft sql server delete command? : SQL Server Architecture
how to avoid cursors? : Sql server database administration
What is your recommendation for a query running very slow? : sql server database administration
What is a coalesce function?
