Gather Stats Strategies for Data warehouse environment

Hello All,

I am wondering about Gather Statistics strategies for a Data warehouse being built from scratch.Any guideline and suggestion will be great?For example: It is very essential after first time initial load, essential for large volume of transaction records load etc. Recommendations may help me to define frequency for same.



posted on 03 May 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds


Which datawarehouse platform are you using ?

For Teradata - When you data volume changes by atleast 10% you will want to refresh the stats

For Bigquery - There are no collect stats

For Snowflake - This is automatically done for you by the services layer


Thanks Npack, I am wondering about Oracle 19c database.


Not very familiar with Oracle 19c, I can find out if I find some time and update