Difference between Cluster and Non-cluster index?
- 32 Answers
- 141580 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 difference between sql and sql server?
What is temporal table?
What is the difference between lock, block and deadlock? : sql server database administration
What is the data type of time?
How do I shrink an ldf file?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Explain what you mean by 3 tier architecture.
What are different types of database indexes?
What is an etl file?
What are the difference between “where” and “having” clause in sql server?
your distribution database is full what will u do
How to list all stored procedures in the current database using ms sql server?
How to convert binary strings into integers in ms sql server?
Do you have any idea about the tcl commands?
