Archives of the TeradataForum

Message Posted: Tue, 25 Oct 2005 @ 10:57:42 GMT

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

Questions regarding the optimizer's decision not to use your JI:

1) Try creating a NUSI and collecting stats on the Division_Number and Account_Number fields in your JI. Also, for good measure, collect stats on those 2 JI columns individually.

2) Try re-creating the JI without 'compression'...perhaps this is a bug specific to compressed JIs

3) Are the left outer joins necessary or could they (all or partly) be replaced with Inner joins and RI (to maintain flexibility)? In other words, is a one to many relationship between the tables guaranteed by the application? If not, then ignore this 3rd point.

Hope this helps.

Thanks,

Clay

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