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

List out some of the requirements to set up a sql server failover cluster?

547

Can we use custom code in ssrs?

591

Tell me about builtinadministrator?

564

Explain SSRS Architecture?

139

Explain the working of sql privileges?

611

What security features are available for stored procedure?

593

What is a fill factor?

627

Is it ok to shrink transaction log?

520

How to create an identity column?

644

How retrieve field names from the table in SQL through JAVA code?

1403

What is the purpose of floor function?

543

Explain tablesample?

556

What is the difference between upgrade and migration in sql server?

598

Explain what are the authentication modes in sql server?

502

How to get the definition of a view out of the sql server?

509