Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38201 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 89 Yes | 9 No |
Post New Answer View All Answers
What is SQL Server?
what are constraints? : Sql server database administration
How do I port a number to sql server?
What are commit and rollback in sql?
What is side by side migration in sql server?
Different types of keys in SQL?
Tell me what is a linked server?
What is the purpose of floor function?
How to check table values in sql server?
What is fill factor and pad index?
How to write a query with a left outer join in ms sql server?
How many types of subqueries are there in sql server?
what is a live lock? : Sql server database administration
What is a bit datatype?
Can you please explain the difference between primary keys and foreign keys?
