Interested to Buy Any Domain ? << Click Here >> for more details...
what is physical sort data and logical sort data in index?
- 2 Answers
- 8270 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is blocking and how would you troubleshoot it?
How to define output parameters in stored procedures?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
Display a roll having miminum marks in two subjects?
how to define testing of network layers? : Sql server database administration
What are the difference between primary keys and foreign keys?
How check triggers in sql server?
How to connect ms access to sql servers through odbc?
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h
How to provide values to user defined function parameters?
What happens if you add a new index to large table?
What do u mean by orphan users, how will u list them in the DB
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
