Interested to Buy Any Domain ? << Click Here >> for more details...
WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX
- 4 Answers
- 11294 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
What is bit data type? What's the information that can be stored inside a bit column?
Explain the use of containers in ssis and also their types?
How will you know when statistics on a table are obsolete?
How to invoke a trigger on demand?
how many clustered indexes can be created on a table? : Sql server database administration
List out what other servers you can use with ssrs?
Explain security with sql azure?
What are the advantages of using cte?
Explain about extended stored procedure?
What is in place upgrade in sql server?
Does sql server 2016 have ssms?
What is use of dbcc commands?
What do you mean by table and field in sql?
What are the database objects? : SQL Server Architecture
What are the different Authentication modes in SQL Server and how can you change authentication mode?
