Archives of the TeradataForum

Message Posted: Tue, 04 Nov 2003 @ 17:21:33 GMT

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

James,

I've seen it before, and it's always been an optimizer bug....I know there are those who believe that it's an acceptable 'tuning' method to drop statistics, but I maintain that it's ALWAYS a bug if giving the optimizer more, correct information results in a poorer access path. (I am assuming that when you say all stats it's a given that they are current).

You don't mention what the table structures are or the SQL to access, but I suspect what's happening is that when there are no stats, the parser is sampling on AMP and you're getting lucky that it choose the correct access path.

Ruth Fenwick
Database Services

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