karthikeyan (2/17/2009)

---

Thanks Chris and sqlmaster!

I am facing a starnge problem while executing the below query. if i execute it seperate it took just 1 second to complete the execution. If...

the above exl formula not working

SELECT Fund.* FROM Fund

LEFT JOIN exception ex ON fund.symbol = ex.symbol AND err_cd >= 20

WHERE ex.symbol is null

i hope it solve some how

definitely 1 option has low cost then 2nd, but if we talk about the locks on table then definitely 2nd option is better then 1st one,

to minimize the lock on...