 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Aug 2005 @ 15:59:34 GMT
| Subj: | | Re: Primary Index vs Single Condition |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, August 11, 2005 11:52 -->
Since you are retrieving a significant percentage of the table rows, it's not surprising that a single table residual condition is faster.
Just for fun, you might also try an inner join between the two tables rather than the IN clause you are apparently using (based on the explain
saying it's an "inclusion merge join").
| |
