Index means to sort the data. Cluster index is physical order of the dat

diffrence between Cluster Index and non Cluster Index

Question Posted / kumar.t

Answer Posted / kumar.t

Index means to sort the data.

Cluster index is physical order of the data.

Non Cluster index is logical order of the data.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between functions and scalar functions?

1279

What is the server name in sql server?

1068

Explain the third normal form(3nf)?

982

How to use the inserted and deleted pseudo tables?

1004

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

1045

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

1152

what do you understand by change data capture?

1077

How to include text values in sql statements?

1098

What is difference between rollback immediate and with no_wait during alter database?

1134

What is the Disadvantage of indexed sequential file.

1130

What does nvl stand for?

992

How to delete duplicate records based on single column from a table?

1105

Explain the benefits of user-defined functions?

1124

What are the advantages of policy management?

1045

How to create a user to access a database in ms sql server using "create user" statements?

996