Dropping Index-Insert data-Create index-Gather Stats??
974722Nov 16 2012 — edited Nov 19 2012I have a script which does things in following order
1.Drop index on a column.(only one index exits on that table t1).
2.Insert Data into that table t1.(using Insert/*+append*/ into t1 select xyz from table2-- approx 200k rows).
3.Create the index again.
4.gather stats on that table+index.
I have put all the 4 things in a procedure.
The procedure is run bi weekely, Is this a good process flow?
My question is when the procedure is executed next time,is it good idea to drop ,create and gather stats on that index?