What are the diffrance between logical index order and physical order

Question

0.00/5 (No votes)

See more:

Hi every body
I have a confusion about the difference between the index logical order and physical order,
I need to know what are the logical order of the index and does it being implemented by the clustered or the non-clustered index because as far as I know that the clustered index defines haw the data is being ordered in the table and this means that it is ordered physically on the other hand the physical order too what does it mean does it mean that there heap table with no index at all
Thanks And Best Regards

What I have tried:

I tried to read some articles from the internet but It confused me more

Posted 14-Dec-19 22:09pm

Member 14479161

Updated 24-Mar-21 5:55am

PIEBALDconsult

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Accepted Answer · 2019-12-14T23:47:00

The physical order is the way the data is stored on disk, which mostly is not ordered.
The logical order is the order defined by the index.

To find out if your SQL Server indexes are fragmented you can use a tool like SQL Index Manager or ApexSQL Discover, see overview here: free-tools-for-sql-server[^]

You might also be interested in this free eBook: Performance Tuning With SQL Server Dynamic Management Views - Redgate Software[^]