Hi grant
thanks for the reply. the table I am concerned about is the company table and it has 16965 tables.
the full scan info :
- Pages Scanned................................: 16965
- Extents Scanned..............................: 2133
- Extent Switches..............................: 5584
- Avg. Pages per Extent........................: 8.0
- Scan Density [Best Count:Actual Count].......: 37.98% [2121:5585]
- Logical Scan Fragmentation ..................: 23.48%
- Extent Scan Fragmentation ...................: 9.75%
- Avg. Bytes Free per Page.....................: 1383.6
- Avg. Page Density (full).....................: 82.91%
At the moment, the performance of scripts querying this table is still good but I am worried that we will see a degredation in speed as the fragmentation increases.