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?
Best Answer
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.