Archives of the TeradataForum

Message Posted: Tue, 21 Oct 2003 @ 20:22:23 GMT

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

Hi, we had a similar problem, if you havn't already done it collect stats in the following way, it solved the problem for us..

collect stats on table1 column (col1, col2, col3, col4, col5, col6, col7);
collect stats on table2 column (col1, col2, col3, col4, col5, col6, col7);
collect stats on table2 column (col1, col2);
collect stats on table3 column (col1, col2);

if it doesn't help maybe you can post the explain(s) with and withouts stats to see whats going on.

Armin

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