Ben wrote:
> 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.
My instinct would be to ignore it. Your regular stats collection
should pick it up.
--
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
Received on Tue Nov 28 2006 - 16:21:55 CST
