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.