>>>On 13/11/2000
>>>Pages Scanned = 1261
>>>Extents Scanned = 158
>>>Scan Density [Best Count:Actual Count] = 100.00% [158:158]
>>>Avg. Bytes Free Per Page = 368.1
>>>Avg. Page Density (full) = 95.45%
>>>
>>>On 25/12/2000
>>>Pages Scanned = 1848
>>>Extents Scanned = 242
>>>Scan Density [Best Count:Actual Count] = 21.94% [231:1053]
>>>Avg. Bytes Free Per Page = 2182.1
>>>Avg. Page Density (full) = 73.04%
>>>
>>>Is there any formula to calculate the fillfactor ?
>>
>>For Example
>>Old Reading = 1261 * 95.45 / 100 = 1204
>>New Reading = 1848 * 73.04 / 100 = 1350
>>Difference = 1350 - 1204 = 146
>>Rate = 146 / 1204 = 0.12
>>FillFactor = 100 / 1.12 = 89.28
>>
>>Is this a correct formula ???
>
>Maybe I don't completely understand what you're looking for.
>
>-Mike

Currently the fillfactor of the fragmented table is 0.
What I'm looking for is a standard formula to calculate the most reasonable fillfactor that I should use.