Interested to Buy Any Domain ? << Click Here >> for more details...
what is physical sort data and logical sort data in index?
- 2 Answers
- 8269 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
How does the report manager work in SSRS?
how many clustered indexes can be created on a table? : Sql server database administration
How to create percentile function?
What are advantages of ssrs or why we should use ssrs?
What is filtered index?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
what is unique and xaml nonclustered index
How to delete multiple rows with one delete statement in ms sql server?
Do you know the cursor types?
what stored procedure can you use to display the current processes? : Sql server administration
Do comments need to go in a special place in sql server 2005?
What is your recommendation for a query running very slow? : sql server database administration
Can we write trigger for view?
What is triggers and its types?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
