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
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What are cascading parameters in ssrs reports?
Explain few examples of stored procedure over triggers?
What is primary key and example?
what is normalization? : Sql server database administration
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is the difference between a local and a global temporary table?
How to use "begin ... End" statement structures in ms sql server?
Can you explain different types of joins?
How to execute multiple stored procedures at one time in sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to convert binary strings into integers in ms sql server?
Can we install sql server 2016 on windows 7?
How many types of attribute relationships are there? : sql server analysis services, ssas
What are the difference between data mart and data warehouse? : sql server analysis services, ssas