Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / prasadhari_m@yahoo.com

Answers were Sorted based on User's Feedback



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

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

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

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

Post New Answer

More SQL Server Interview Questions

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

Explain logical operators in sql server?

0 Answers  

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

Explain filtered indexes?

0 Answers  

what are file groups?

3 Answers   Evalueserve,

How many types of triggers in sql server?

0 Answers  

What is implicit mode in sql server?

0 Answers  

What is outer join in sql server joins?

0 Answers  

Explain the steps needed to create a scheduled job?

0 Answers  

How to change a login name in ms sql server?

0 Answers  

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

Explain the advantages of merge replication?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories