On 02/05/13 15:33, Nick Upson wrote:

> as I now understand it, if I restore the database with -USE_ALL_SPACE &
> then do gfix -use reserve I will have a database which has all the static
> data on full pages and the data that does change will quickly go back to
> the 80/20 page usage. Something like 90% is static so I'm hoping this will
> give me some improved performance on queries against the static data.

Basically, yes. But the amount of space left free is subject to what Ann
said when she told me off originally, in this thread! ;-)

Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL

Company Number: 05132767