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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
