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

Mention the differences between sql server and mysql.

681


What stored procedure can you use to display the current processes?

662


What is partition index in sql server?

798


What is a trigger what are the advantages of trigger?

695


How do I edit a stored procedure in sql server?

682






How do I clean up sql server transaction log?

744


How to rebuild the master database?

750


Tell me what is sql profiler?

795


Explain about analysis services?

760


What are the types of database recovery models?

787


What is a filestream?

737


What is forward - only cursors / read only cursor?

724


What does indexation mean?

696


What are dml triggers and types of dml triggers?

716


What is sql server transaction log file?

709