Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 148070 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / kshirsagar sambhaji
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
Whereas in case of non-clustered index the leaf level is
actually a pointer to the data in rows so we can have as
many non-clustered indexes as we can on the db.
| Is This Answer Correct ? | 48 Yes | 19 No |
Post New Answer View All Answers
How to include text values in sql statements?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to populate a table in sql server?
What happens if date-only values are provided as date and time literals?
Give an example of why you would want to denormalize a database
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is ssrs?
What is mean by dml?
What is the recovery model? List the types of recovery model available in sql server?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
Characterize join and name diverse sorts of joins?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?
What are trace files?
What is bit data type? What's the information that can be stored inside a bit column?
