On May 10, 12:39 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> Adding a column is just an update in dictionary. It is immediate.
> Filling the new column will take more time.
> There will mey be not fragmentation but row migration after that
> and a table reorganization may be useful (depending on how many
> rows will migrate).
>
> Regards
> Michel
well.. i takes not even a second to add a new column WITH a default
value of 0 (through Toad) on 19M records table.
Can you tell me some more about table reorganization? Do I have to
worry about it or just leave it up to Oracle magic? :)
Received on Thu May 10 2007 - 08:46:51 CDT
