On 11/30/10 5:54 PM, Kevin Grittner wrote: > "T.H."<calinet6(at)gmail(dot)com> wrote: > >> Also, are there any better ways you can think of doing such an IN >> query, using non-subselect means that might be more efficient? > > Have you tried the EXISTS predicate? > > -Kevin >
Just looking into it now, thanks for the suggestion. Is there a reason that EXISTS is generally faster than IN for this sort of query?