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

Explain syntax for viewing trigger?

708


How do I start sql server 2016?

688


Why do we need normalization?

663


What is difference between drop truncate and delete?

734


What is ssrs?

109






What is sql server schema compare? How we can compare two database schemas?

768


What is the maximum length of an alert name?

770


What are trace flags?

766


How to update muliple row in single query?

798


How to receive returning result from a query?

749


How do I start sql server agent automatically?

690


Explain transaction isolation levels in sql server?

744


Do you know how to send email from database?

729


What is an indice?

763


Explain the Ways to improve the performance of a sql azure database?

78