Difference between Cluster and Non-cluster index?

Answer Posted / james bond

All are mad with cluster index.
they don't know wht the exact difference.
(All these are book worm.they just a ctrl+C and Ctrl+v and
nothing else)

Clustered index proper way to findd desired data like
rowndex(physical form of data) and non clustered is
mapping of these clustered index in differnt form.

(Don't try to keep as written on your mind. think it and
then use it??)

Is This Answer Correct ?    62 Yes 63 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between inner join and full join?

554


How to write a query with a full outer join in ms sql server?

560


Are resultset updatable?

526


Can we write ddl in trigger?

498


What is SQL Azure Data sync?

105






What is query processing?

545


How can change procedure in sql server?

526


what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

560


What are “lock” hints?

593


What the different components in replication and what is their use?

519


What is @@rowcount in sql?

566


Can I delete event logs?

546


What is the difference between having clause and where clause in sql server?

575


Define right outer join?

546


What do you think of this implementation? Can this be implemented better?

535