Hello,
After using DBMS_REDEFINITON one one table i run a collection statistics for this table with:
BEGIN
dbms_stats.gather_table_stats ( ownname => 'EPK', tabname => 'AGD06', ESTIMATE_PERCENT => 100, cascade => true, degree => 8);
END;
/
I run an explain plan
On AGD06 table i have a full table scan.
I collect an other time the statistics on my table with the same sql and i run an other explain.
This time my execution plan is good.
Why i must run tow times my statistics collection ?
I don't understand.
Thanks for your help