Re: renaming a column and statistics generation

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Wed, 14 Jan 2009 17:07:46 -0800
Message-ID: <26fdee6e0901141707u277823fcw1594decaf828b4bb_at_mail.gmail.com>

Nevermind, The DBA's already agree that they misspoke. Thanks again.

2009/1/14 Michael Moore <michaeljmoore_at_gmail.com>

> Thanks Dion.
> I've looked through the Oracle documentation to find information on this
> but found nothing. If anybody can refer me to documentation, it would be
> very much appreciated.
> Mike
>
>
> On Wed, Jan 14, 2009 at 4:57 PM, Á¶µ¿¿í <ukja.dion_at_gmail.com> wrote:
>
>> No, renaming column does not recalculate the statistics instantly.
>>
>> Dion Cho
>>
>> 2009/1/15 Michael Moore <michaeljmoore_at_gmail.com>
>>
>> A co-worker wanted to rename a column on a very large table. The DBA's
>>> told him, "no way", because it was cause the statistics to be recalculated
>>> which is a very long process.
>>>
>>> I'd like a second opinion. Does renaming a column cause statistics to be
>>> regenerated? If so, is there any workaround such as LOCK_TABLE_STATS where
>>> you could lock the stats before the rename, and unlock them after the
>>> rename?
>>>
>>> Thanks,
>>> Mike
>>>
>>
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 14 2009 - 19:07:46 CST