Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11324 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 global temp table?
What is dirty page?
Does full backup break log chain?
What is tcl in sql server?
What is a constant or literal in ms sql server?
Why variables called the most powerful component of ssis?
How to create a new login name in ms sql server?
Differentiate between mongodb vs. Sql server?
How can i Relate Tables in SSIS
What is SQL Azure Data sync?
Can sql servers linked to other servers?
What is difference between equi join and inner join?
Difference between LEN() and DATALENGTH() in sql server ?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is the purpose of linked server configuration in sql server?
