|
|
Archives of the TeradataForum
Message Posted: Mon, 01 Sep 2014 @ 12:56:56 GMT
Subj: | | Re: Left Join leading to product Join |
|
From: | | Dieter Noeth |
Robert Briggs wrote:
| You do realize that the WHERE clause can't be evaluated until AFTER the outer joins are performed? Your WHERE A11.PRODUCT_GN_NBR =
'2874.80469' is only evaluated after all of the outer joins have been completed resulting in an enormous spool file. | |
No, that's wrong. If you check Explain you see that the optmizer already applies the filter within the first steps.
There must be some other reason why this query runs out of spool.
Dieter
| |