logical fragmentation vs. extent fragmentation

• KATHLEEN Y ZHANG

  Hall of Fame

  Points: 3534

  More actions

  May 26, 2006 at 1:47 pm

  #112423

  I run 'DBCC SHOWCONTIG WITH TABLERESULTS, all_indexes' on one of our production databases. The result shows across all the indexes, logicalFragmentation is below 10% while extent fragmentation is almost all above 10%. Could anyone pls shed some lights on the difference?

  Thanks!

   

• raj-247939

  SSCertifiable

  Points: 5999

  More actions

  May 30, 2006 at 3:41 am

  #640622

  Hi ,

   

  Logical Scan Fragmentation is the percentage of out of order pages in index.

  The only way to reduce logical fragmentation is to create the index again.

  If there are lot of connection or users are using the table then run DBCC INDEXDEFRAG.

   

  HTH

  Killer