Re: adding a new column to 19 million records table - how does it really works on 10g?

Home -> Community -> Usenet -> c.d.o.server -> Re: adding a new column to 19 million records table - how does it really works on 10g?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 10 May 2007 06:39:48 +0200
Message-ID: <4642a215$0$16457$426a74cc@news.free.fr>

"Joe" <joe1977_at_tlen.pl> a écrit dans le message de news: 1178764619.029339.113040_at_w5g2000hsg.googlegroups.com...
|I have a pretty big table with 10 columns, most varchars2 (50).
| adding a new column to table that already have 19M records takes half
| a second (through Toad).
| question: how does oracle organize data inside table space, and does
| on should make any database defragmentation after adding additional
| column to allready so much filled-out table?
|
|
| thanks for help
|

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 Received on Wed May 09 2007 - 23:39:48 CDT