Re: renaming a column and statistics generation

From: (wrong string) 조동욱 <ukja.dion_at_gmail.com>
Date: Thu, 15 Jan 2009 09:57:11 +0900
Message-ID: <43c2e3d60901141657p577cef84ra9a8fefeac2fc8aa_at_mail.gmail.com>

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 - 18:57:11 CST