|
|
Archives of the TeradataForum
Message Posted: Wed, 27 Aug 2014 @ 10:12:36 GMT
Subj: | | Re: Left Join leading to product Join |
|
From: | | Mark Young |
Looking at the low confidence in the product join step, I would be thinking that maybe your statistics are non existent for the related tables,
or stale, and the step is potentially pulling back a large number of rows - if your site uses viewpoint, try looking at the running explain to see
if any earlier steps that might be involved in the data for this step, show a big des repents between estimated and actual
| |