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.

Thanks,Rajneesh

rajneesh4u

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




nVector03-May-20

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

rajneesh4u04-May-20

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

nVector04-May-20

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