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

What is a raid and what are different types of raid configurations?

631


what protocol both networks use? : Sql server database administration

542


What do you mean by table and field in sql?

558


What is the difference between count () and rowcount ()?

523


Why do we partition data?

620






Explain trigger classes i.e. Instead of and after trigger?

489


What Is Rdbms?

674


List out the difference between union and union all in sql server?

522


How do I view a procedure in sql server?

541


How you would rewrite the sql query to return the customerid sorted numerically?

575


Do you know what are various aggregate functions that are available?

528


How to bind a view to the schema of the underlying tables?

587


What is mscorsvw.exe - process - microsoft .net framework ngen?

529


Is null vs coalesce?

509


How can you fetch alternate records from a table?

545