Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146166 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 select all columns of all rows from a table with a select statement in ms sql server?
How to write a query with a left outer join in ms sql server?
Can we write ddl in trigger?
What is sub-query in sql server? Explain its properties.
Difference between LEN() and DATALENGTH() in sql server ?
Ms sql server index?
What is a transaction and why is it important?
What is the use of toad or sqldbx.?
Do comments need to go in a special place in sql server 2005?
How to get a list all databases on the sql server?
How many types of built in functions are there in sql server 2012?
What are sql server procedures?
Explain indexed views and partitioned view with their syntax.
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What are distinctive joins find as a part of sql?
