When you create Clustered Index data is physically sorted based on the co

what is physical sort data and logical sort data in index?

Question Posted / monal

Answer Posted / monal

When you create Clustered Index data is physically sorted
based on the column used in clustered index.

don't know what is logical sort data.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I trace a query in sql server?

933

Does partitioning help performance?

918

What is the difference between primary key and unique constraints?

940

What is the difference between mysql and sql server?

994

What are the tools available in market as an alternative to sql server reporting services?

129

What is report snapshot?

156

What is proper subset of candidate key?

983

What is sharding?

116

Explain about extended stored procedure?

914

What you can do to delete a table without the delete trigger firing?

951

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1025

Why we use functions in sql server?

1054

Is truncate autocommit?

924

What is the difference between a stored procedure and a user defined function?

1010

How to update a field in SQL after ALTERING a row?

1218