In this previous post I asked whether 100% logical scan fragmentation is always worse than 85% local scan fragmentation for table/index scans. (To be precise, I was talking about a B-tree table, i.e. a table with a clustered index).   The answer is no. 100% logical scan fragmentation is not always worse than 85% logical scan fragmentation ...