Re: renaming a column and statistics generation
- From: "조동욱" <ukja.dion@xxxxxxxxx>
- To: michaeljmoore@xxxxxxxxx
- Date: Thu, 15 Jan 2009 09:57:11 +0900
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:
