Archives of the TeradataForum
Message Posted: Fri, 13 Jan 2012 @ 14:38:10 GMT
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.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|