Statistics on temporary table
I see in the log that recstats is running, but at the end there is no stat and the performance is not there (full table scan)... when I use the older :
DBMS_STATS.GATHER_TABLE_STATS (ownname=> [DBNAME], tabname=>[TBNAME], estimate_percent=>1, method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1',cascade=>TRUE);