Hello Experts,
I need to load a table from three different staging tables.
Each of the three source staging tables have data from a subsidiary and can be ready for load into the final table independently. so they can happen on different moments or in parallel.
I need help on how to plan the ANALYZE_STATISTICS on the final table:
After each data load:
Pros : easy to schedule after each subsidiary batch load.
Cons: The issue is that it may happen that while an analyze statistics is running on the table, others (ANALYZE_STATISTICS on the same table) can be triggered, errors will be reported as only one ANALYZE_STATISTICS can be running on a table at a time.Once after the three subsidiaries have been loaded:
Pros : Efficient use of ANALYZE_STATISTICS
Cons : If for any reason one subsidiary have a problem and miss a daily load, the analyze statistics will not be triggered and queries performances may be impacted (?).
How can we manage this, any other suggestion is welcome.
Many thanks.
Mkheir.
