Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38169 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 are the diifferences between the ms sql server vs mysql?
What is difference between primary key and foreign key?
How to add additional conditions in SQL?
How important do you consider cursors or while loops for a transactional database?
What are the system database in sql server 2008?
Can you name some of the dml commands in sql?
Explain table valued parameters in sql server? Why tvp used?
What are the recovery models for a database?
What are the properties of sub-query?
How do I start sql server agent automatically?
How to sort query output in descending order in ms sql server?
What is transact-sql ddl trigger?
What are the advantages of stored procedure in sql server?
What is the function of inner join?
When should you use an instead of trigger?
