Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11099 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 command is used to create a database in the sql server and how?
What are pessimistic lock and optimistic lock?
What is the default fill factor value?
What do we need queues in sql service broker?
What is the contrast between sql and pl/sql?
What are the database roles? : sql server security
What are the system database in sql server 2008?
Is it important for a database administrator to understand the operating system and file access?
What is filestream?
What are the restrictions that views have to follow? : SQL Server Architecture
Sql server reporting services vs. Crystal reports.
Are semicolons required at the end of sql statements in sql server 2005?
what is denormalization? : Sql server database administration
Define normalisation?
What do you understand by triggers and mention the different types of it?
