Statistics not collected on Insert-Select Based on the information here, I expected the statistics to be automatically collected during an Insert-Select operation on a new table in Oracle. However, I don't see any table-level statistics gathered after an insert-select operation.
I have set the parameter _optimizer_gather_stats_on_load to TRUE.
As per requirement (this only works for new tables), I created a new table. There are no rows prior to insert-select and 500 rows post insert-select operation.
Is there something else I am missing?
This only works with direct path loads: INSERT /*+ APPEND */ INTO ... SELECT ....
It does not apply to conventional path insert (INSERT INTO ... SELECT ..., without /*+ APPEND */ hint).
This is also explained on the site behind the link.