Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: adding column to table
DA Morgan wrote:
> Ben wrote:
> > 9.2.0.5 EE AIX5L
> >
> > when adding a nullable number column to the end of a table, should you
> > anlayze the table before allowing it to be used in production?
>
> Adding a column with no data? Or adding a column that has some data?
> How is the column being used?
> Any indexes?
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
The column that is going to be added will not have data until the application inserts new rows with a value in that column. There are no indexes on that column. Received on Tue Nov 28 2006 - 15:31:10 CST