what is physical sort data and logical sort data in index?
- 2 Answers
- 7653 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh b patil
As it is explained in the Answer #1, The Clustered Index
uses the Physical Sorting, just like the Page Index at the
Beginning of your book, but The Logical sorting means it
will be done with the Non Clustered Indices, as you all know
the data in the server stored on the multi page files,
because the amount of data stored on the database is huge,
So in case of the logical sorting depending upon say query
results the records are at your disposal which you have got
after filtering using a where clause, then the data is
coming from different pages and there is no continuation
like SNO column in case case of select *, So the pages where
the desired data is found are actually will hold the
references, means the record say #3, from page #3, will hold
the address of the Previous record address as well as the
next record address just like your Double Linked List Nodes,
I hope now logical sorting is explained by me here.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Where the sql logs gets stored? : sql server database administration
Explain what is the main purpose of having conversation group?
What are triggers? How do you invoke a trigger on demand?
Explain optimistic and pessimistic concurrency?
what is the maximum size of a row? : Sql server database administration
What is difference between group by and having?
What is cross join in sql server joins?
How to create user defined functions with parameters?
What are different types of views?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
what is difference between view and Dip.
what are the different ways to return the rowcount of a table?
What is the difference between Clustered and Non-Clustered Index?
