On 8/3/06, Christian Rengstl <Christian(dot)Rengstl(at)klinik(dot)uni-regensburg(dot)de> 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