Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147165 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 Disadvantage of indexed sequential file.
How many types of subqueries are there in sql server?
What is read uncmmited?
What is subreport?
What is the sql server agent?
what is the difference between Tabular and Matrix report?
What is temporal data type?
Explain the steps to use transact-sql cursor?
Where cross join is used?
What is field in algebra?
What is dbcc? Give few examples.
How to generate create function script on an existing function?
What authentication modes does sql server support?
What is a covering index?
What is a document index?
