Nevermind, The DBA's already agree that they misspoke. Thanks again. 2009/1/14 Michael Moore <michaeljmoore@xxxxxxxxx> > 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 >>> >> >> >> >> >