Hi Thomas,
Never say never (oh bugger, I've just gone and done
it myself).
A large table accessed via a FTS for various
important reporting requirements has permanently shrunk in size from 10G to
100M (say list of Informix customers ;)
Business requirements have changed and you need to
add some columns to a table resulting in mucho row
migration.
You were told (incorrectly) that rows would grow
significantly after loading (honestly) but now the 80 pctfree value you've set
is causing problems for other really important reports.
There are of course other cases but you
get my point ;)
Cheers
Richard
|
Title: Message
- Re: table reorganizations Tanel Poder
- Re: RE: table reorganizations Michael Thomas
- RE: table reorganizations Jamadagni, Rajendra
- RE: table reorganizations Mercadante, Thomas F
- RE: table reorganizations Michael Thomas
- Re: RE: table reorganizations Nuno Pinto do Souto
- RE: table reorganizations Jared Still
- Re: table reorganizations Mladen Gogala
- Re: table reorganizations Nuno Souto
- Re: table reorganizations Richard Foote
- Re: table reorganizations Richard Foote
- Re: table reorganizations chris
- RE: table reorganizations Mercadante, Thomas F
- Re: table reorganizations Rachel Carmichael
- Re: table reorganizations Mladen Gogala
- Re: table reorganizations Rachel Carmichael
- Re: Re: table reorganizations Tanel Poder
- RE: table reorganizations Niall Litchfield
- Re: table reorganizations chris
- RE: table reorganizations chris
- RE: table reorganizations chris