Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146903 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
Can we use pragma autonomous_transaction in trigger?
What is difference between rollback immediate and with no_wait during alter database?
How to get the definition of a user defined function back?
What is sparse columns of sql server 2008?
Explain how many types of relationship?
What is mapping schema?
List the advantages of using stored procedures?
What is bcp? When does it use?
How do I start sql server 2017?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
How to resolve the orphan use problem? : sql server security
Can a database be shrunk to 0 bytes, if not, why?
what is raid? : Sql server database administration
Which tcp/ip port does sql server run on? How can it be changed?
What is the default Port No on which SQL Server listens?
