Re: renaming a column and statistics generation

From: (wrong string) 조동욱 <>
Date: Thu, 15 Jan 2009 09:57:11 +0900
Message-ID: <>

No, renaming column does not recalculate the statistics instantly.

Dion Cho

2009/1/15 Michael Moore <>

> 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

Received on Wed Jan 14 2009 - 18:57:11 CST

Original text of this message