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

What are ddl (data definition language) statements for tables in ms sql server?

1105

Explain active/passive and active/active cluster configurations?

1063

What is the difference between function and stored procedure in sql server?

1082

What is the Main Difference between ACCESS and SQL SERVER?

1142

What are the security related catalog views? : sql server security

954

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

957

How to delete an existing database user?

1022

Why people hate cursor?

1151

What are the properties of the transactions?

1119

Explain Geometry datatype in sql server 2008 with example

997

List the different index configurations possible for a table?

936

What is repeatable read?

1024

Difference between Logical Page and Physical Page in SSRS.

476

What is the difference between the 2 operating modes of database mirroring?

1115

Why do you need a sql server?

1115