Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 145979 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 does executeupdate return?
What are the fixed server level roles? : sql server security
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How is sql server used?
Explain full-text query in sql server?
Differentiate between truncate vs delete in mssql?
Explain insert into select statement?
Can you explain what is sql server english query?
Mention the different types of triggers?
What is an active database?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Can we add a cpu to sql server?
What is trigger in salesforce?
What is the maximum size of sql server database?
What are types of subqueries?
