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
