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
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,