Suggestion about collect stats

Database
Enthusiast

Suggestion about collect stats

Hi

I have 20 tables for my application in DWH, i'm planning to  do  collect stats on all the columns of these 20 tables.

All these tables are used for reporting,Analysis and Adhoc analysis.

Need all your suggestion it will be suggestable to do collect stats on all the columns  for these tables.

Thanks & Regards

Sunny

1 REPLY
Senior Apprentice

Re: Suggestion about collect stats

Hi Sunny,

you probably can't afford to (re)collect all those stats.

Stats are only usefull when they actually change the optimizer's plan.

There are some articles/blogs about collecting stats, i'd recommend reading them first,

e.g. http://developer.teradata.com/database/articles/statistics-collection-recommendations-for-teradata-1...

Dieter