"Preeti Ambardar" <[EMAIL PROTECTED]> writes:
> SELECT ...
> FROM mstuserprofiles cpuser RIGHT OUTER JOIN mstcompanies
> ON cpuser.fktrdid_usptradhouseid = mstcompanies.fktrdid_cmptradhouseid
> AND cpuser.pkuspid = mstcompanies.cmpcontact_userid
> LEFT OUTER JOIN mstcurrency
> ON mstcompa
I am working on a query qhich has lot of RIGHT and LEFT Outer joins. This takes
almost 2 hours to execute.
SELECT mstcurrency.pkcurid, mstcurrency.curswift_code,
mstproducts.pkprdid, mstproducts.prdname,
mstproducts.fkcnvid_prdbaseuom,
cpuser.uspname || ' ' || cpuser.uspsurname as uspnam
