Does renaming table require rerunning stats?
tx103108Apr 26 2011 — edited Apr 27 2011OS: OEL (latest) 64-bit
DB: 11gR1
I need to create a copy of a large table A in production (call the new table B). The data is the same but the physical layout of the tables is different (different partitioning scheme is being used between table A and B).
When I go to move table B to replace table A (which will eventually be dropped), do I have to rerun stats on table B?
That is,
(1) table A become table A_OLD
(2) table B becomes table A
Do I need to rerun stats on table A in step (2)? Is there anything else that needs to be done?
( I am doing this to limit the impact to the GUI which uses this table -- the final table name does not change so the GUI should not be affected.)
Cheers!