IN SIMPLE WORDS, CLUTER INDEX IS PHYSICALY STORED ONE. NONCLUSTER INDEX

Difference between Cluster and Non-cluster index?

Question Posted / bala murugan28

Answer Posted / bala murugan28

IN SIMPLE WORDS,
CLUTER INDEX IS PHYSICALY STORED ONE.

NONCLUSTER INDEX IS LOGICALLY STORED ONE.

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

When we should use and scope of @@identity?

995

Why use update_statistics command in sql server?

1044

How can you insert null values in a column while inserting the data?

1275

How you can change the database name in SQL SERVER?

1189

Differentiate between mongodb vs. Sql server?

1086

How to use column default values in insert statements in ms sql server?

1025

Differentiate between sql temp table vs table variable?

876

What are unicode character string data types in ms sql server?

1241

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

973

What is the difference between dbcc indexdefrag and dbcc reindex?

981

How do I setup a sql server database?

1065

What is the tcp/ip port on which sql server runs?

1147

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1258

How to test a dml trigger in ms sql server?

1037

What is indexing explain it with an example?

1004