THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Logical scan fragmentation
Performance impact: Logical scan fragmentation -- 100% may not be as bad as 85%
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 ...
June 22, 2009
Brought to you by