 |
 |
Archives of the TeradataForum
Message Posted: Fri, 23 Apr 2004 @ 15:42:33 GMT
| Subj: | | Left Outer Join on Partition (PPI) table |
| |
| From: | | Sada Shirol |
Hi everyone: We are seeing incorrect results with Left Outer Join on a partition (PPI) table that is access by non-partition column resulting
in row hash match scan. However, we see correct results when an outer join is used on partition table and is accessed by partition columns. It
both the cases explain shows optimizer is using merge join. We are on V2R.05.00.01.05 Any insight/possible work around would be greatly
appreciated.
Sada Shirol
| |
