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

Is it possible in sql table to have more than one foreign key?

1020

Can you explain important index characteristics?

984

Can you explain powershell included in sql server 2008?

929

Explain identity in sql server?

995

What is extent? Types of extents?

1169

Why we should not use triggers?

959

Define model database?

963

Explain mixed authentication mode of sql server?

1040

what is the difference between Delete and Truncate command in SQL

1137

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1067

What is code near application topology?

279

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1050

How to convert numeric values to integers in ms sql server?

1072

How to see the event list of an existing trigger using sys.trigger_events?

1062

Why should we go for stored procedures? Why not direct queries?

1085