Difference between Cluster and Non-cluster index?
- 32 Answers
- 138539 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ricky
when we create a primery key it automatically create
aclustered index. clustered index is a index which reorder
the records in a way the recored are physically sorted.
or
in clustered index the logical order match the physical
order.
whre as the non-clustered index the logical ordered of the
recored does not match the physical order of the recored on
disk.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the template in sql?
How do you handle datasets larger than 50 gb?
List out the different types of locks available in sql server?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How can I tell if sql server is 32 or 64 bit?
What are rows and columns?
What Are the Main Features of SQL Azure?
How can you stop stored procedures from recompiling?
How you can find out if an index is useful to the optimizer?
What are the advantages of using a stored procedure?
Explain about thread and memory management process of SQL?
Is truncate autocommit?
What are rest-style architecture's?
Can you explain powershell included in sql server 2008?
How to filter out duplications in the returning rows in ms sql server?
