On 8/3/06, Christian Rengstl <Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx> 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
