renaming a column and statistics generation

From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Wed, 14 Jan 2009 16:38:28 -0800
Message-ID: <26fdee6e0901141638q7e75b737q91ff23e24d14a020_at_mail.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:38:28 CST