Gather Stats Strategies for Data warehouse environment

404

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

Post Comment

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

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