Archives of the TeradataForum

Message Posted: Tue, 28 Oct 2003 @ 15:43:59 GMT

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

Have you tried collecting stats on the individual columns that make up the indexes?

Collect stats on table A Column cust_cd
Collect stats on table A Column order_cd

And the same stats for table B

Collect stats on table B Column cust_cd
Collect stats on table B Column order_cd

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