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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what does the automatic recovery do? : Sql server administration

732


What is sql stored procedure?

782


Do you know what is blocking?

727


What are the features of Embedded SQL

855


What is difference between join and natural join?

643






Are semicolons required at the end of sql statements in sql server 2005?

729


What is difference between equi join and natural join?

708


What are the advantages of using stored procedures?

686


What is trigger in salesforce?

672


What is a database in ms sql server?

735


What is the difference between having clause and where clause in sql server?

775


Explain primary key in sql server?

749


What are the basic functions for master, msdb, model, tempdb and resource databases?

747


What is bit data type? What's the information that can be stored inside a bit column?

684


Will sql server 2005 allow you to reduce the size of a column?

702