Hi all,

I need to optimize the following query,

Select A.*,B.* from A LEFT OUTER JOIN B ON(A.nm=B.nm AND A.dt=B.dt AND A.cd=B.cd AND B.lnnbr = 0)
UNION
Select A.*,B.* from A LEFT OUTER JOIN B ON(A.nm=B.nm AND A.lnnbr=B.lnnbr AND B.lnnbr >0)

Your expert suggestion is welcome.

Thanks in advance.

Thanks,
Rajan