Click here to Skip to main content
15,169,285 members
Please Sign up or sign in to vote.
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
Updated 24-Mar-21 6:55am

1 solution

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[^]

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900