Difference between Cluster and Non-cluster index?

Answer Posted / rajeev goel

CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.

NON-CLUSTER:- non-cluster like subpart of any part.
for example- content. in side content another subcontent
and so on......

Is This Answer Correct ?    24 Yes 109 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define indexes?

611


How will you know when statistics on a table are obsolete?

614


Can I save my report as html, excel or word? : sql server management studio

550


Does the unique constraint create an index?

574


What is a result set object returned by mssql_query()?

584






What is the difference between executequery () and executeupdate ()?

524


How many types of triggers in sql server?

525


How to count rows with the count(*) function in ms sql server?

542


How do you drop an index?

507


How does index makes search faster?

607


What are sql dirty pages?

568


How to create a store procedure with encryption?

527


How to link tables in sql server?

483


how many triggers you can have on a table? : Sql server database administration

501


How to make a remote connection in a database?

539