Optimizer Gather Stats on Load
As per below oracle document from 12c when we do CTAS or IAS it should collect the statistics.
Online Statistics Gathering for Bulk Loads (Doc ID 2019634.1)
We have Oracle EXADATA 12.2.0.1 (April2020 CPU). When i do the explain plan for ctas it does not show the optimizer gather statistics. Please see below. Also after CTAS it did not gather the stats and NUM_ROWS is empty.
I can see _OPTIMIZER_GATHER_STATS_ON_LOAD is already set to True
explain plan for create table psoprdefn_test as select * from psoprdefn
select * from table(DBMS_XPLAN.DISPLAY);
Plan hash value: 342619065
---------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |