I have created one Temp table which is truncated and load from Informatica Powercenter.
My question is those temp tables required DBSTATS, after the truncate and load happened? or it will automatically take the DBSTATS. because I'm facing an issue at the first time load. second time load looks fine
1 Replies
Starting with Oracle 12cR1, Oracle will gather automatic statistics in bulk load operations, making it unnecessary to gather statistics subsequently. This means extra table scans for statistics collection are unnecessary and there is less chance that you will forget to gather statistics after bulk loads.
Operations such as CTAS
Bulk direct path insert select
A bulk load into an empty partitioned table will trigger the gathering of global statistics, but no partition-level statistics.
In any of these cases, you won't need to gather statistics, Oracle will do it automatically.