Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11268 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
Explain having clause?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is the new security features added in sql server 2016? : sql server security
how you can configure a running aggregate in SSRS?
How to apply filtering criteria at group level with the having clause in ms sql server?
How to drop existing views from a database in ms sql server?
What are the five major components of a dbms?
List some of the rules that apply to creating and using a ‘view’
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Explain Capacity planning to create a database? and how to monitor it?
How to verify a login name with sqlcmd tool?
How do I port a number to sql server?
Does order by actually change the order of the data in the tables or does it just change the output?
What is difference between line feed ( ) and carriage return ( )?
How to drop an existing table with "drop table" statements in ms sql server?
