We are doing a collect stats every time the daily data load is complete.
We run the following command in the ETL process as an after sql for each table load, it looks very primitive and the ETL has been around for 8 year now (guessing)
INSERT INTO tableA SELECT * FROM tableB ..
Wondering if there is any efficient way i can automate the process w/o having to write these bunch of lines.
Like a collect stats procedure that will just do the stats by just passing the table name
For example.. some_(default)tera_collectstats_procedure.tableB = Done !!
One line and peace of mind....and input will he helpful
You can consider implementing Stats Manager (controlled via VP) in order to automate the process of collecting and refreshing stats.
We are currently using it successfully at our customer site.