Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 14:02:24 GMT

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

What about statistics for the joining table.

I have seen this where a query will run for hours in a product join and use 100% of the cpu on the nodes.

You cancel it, collect statistics on the tables, and the query runs in minutes.

Just a thought.

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