Archives of the TeradataForum

Message Posted: Fri, 13 Jan 2012 @ 14:38:10 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Generate collect statistics statement

From:		Dave Wellman

Hi James,

1) Almost certainly this is a simlar situation.

2) BE AWARE that doing what you're suggesting is likely to lead to an awful lot of wasted cpu and disk io resources. Yes, you often need stats on the columns used in a WHERE clause, but just doing a blanket process which is what I think you're looking for probably not your best bet. Even if a column is used in a WHERE clause, if collecting stats on that column doesn't change the structur of the explain (by structure I mean order of tables, type of join etc) then collecting stats is a waste of time. You really need to take a more detailed look at your processing.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)