FreeLists / oracle-l / Add column(s) to an existing table

["Roger Xu" <Roger.Xu@xxxxxxxxxxx>]

Hi List, 




Does the following SQL touch every single row immediately?

ALTER TABLE supplier
ADD (supplier_tax_id varchar2(10),
            supplier_timezone varchar2(5) ); 

What is the best way to add column(s) to an existing table with millions of 
rows?

Thanks,

Roger


This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System.