On 8/3/06, Christian Rengstl <[email protected]> wrote:
> ...
> Unfortunately the query takes pretty long for the big table, so maybe one of you has a suggestion on how to make it
faster.
>
try smth like this:
select val1, val2, crit from mytable as a where pid='somepid' and
exists(select 1 from myCritTable as b where a.crit = b.crit);
--
Best regards,
Nikolay
