Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11321 Views
- CarrizalSoft Technologies, L&T, I also Faced
- E-Mail Answers
Answer Posted / shaurabh thapa
Cluster Index is faster because it has data in the leaf
nodes along with the key. Non cluster on the other hand uses
cluster index key to search the data and therefore
relatively less fast.
| Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
Which are new data types introduced in sql server 2008?
what types of replication are supported in sql server? : Sql server database administration
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is unique key constraint?
What are the different authentication modes in sql server?
What is inner join in sql server joins?
Can we perform backup restore operation on tempdb?
What is spatial and temporal data?
What the difference between UNION and UNIONALL?
Can We Use Data-grids For Our Report In Ssrs?
Explain sub-query?
Explain alternate key, candidate key and composite key in sql server?
How to execute a sql statement using odbc_exec()?
If no size is defined while creating the database, what size will the database have?
What is the report builder?
