Difference between Cluster and Non-cluster index?

Answer Posted / kenatrivedi

Clustered Index is Clustered Index











Non-cluster Index is Non-cluster

Is This Answer Correct ?    61 Yes 255 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how will add additional conditions in sql?

739


How many clustered indexes there can be on table ?

751


Explain transaction server consistency?

689


Do you know how to store and query spatial data?

780


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

715






You want to implement the one-to-many relationship while designing tables. How would you do it?

709


What is a transact-sql statement batch in ms sql server?

670


How to use "begin ... End" statement structures in ms sql server?

681


Mention the command used to rename the database.

725


Do you know what is replace and stuff function in sql server?

677


What is data block and how to define data block size?

781


What is a transaction and why is it important?

734


Explain active/passive and active/active cluster configurations?

798


what is a check constraint?

845


Tell me what are cursors and when they are useful?

702