Re: renaming a column and statistics generation
- From: "Michael Moore" <michaeljmoore@xxxxxxxxx>
- To: "조동욱" <ukja.dion@xxxxxxxxx>
- Date: Wed, 14 Jan 2009 17:00:15 -0800
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@xxxxxxxxx> wrote:
> No, renaming column does not recalculate the statistics instantly.
>
> Dion Cho
>
> 2009/1/15 Michael Moore <michaeljmoore@xxxxxxxxx>
>
> 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
>>
>
>
>
>
Other related posts:
