I ran the showcontig on the table and with the result below. What does it means when Extent Scan Fragmentation is high? Could I do anything to improve the table performance? thanks DBCC SHOWCONTIG scanning 'table' table... Table: 'table' (1435152158); index ID: 0, database ID: 5 TABLE level scan performed. - Pages Scanned................................: 454 - Extents Scanned..............................: 60 - Extent Switches..............................: 59 - Avg. Pages per Extent........................: 7.6 - Scan Density [Best Count:Actual Count].......: 95.00% [57:60] - Extent Scan Fragmentation ...................: 88.33% - Avg. Bytes Free per Page.....................: 299.9 - Avg. Page Density (full).....................: 96.30%