Optimisation of code
419019Sep 18 2006 — edited Sep 19 2006Hi all,
I have a piece of select which is taking too much time is there any way to further optimise this?
(SELECT rae.i, rae.b(bu_req,'Y',rae.p,'N',null) pr, rae.ccy,
gs.int_rec,
NVL (rdie.int_acc, 0) + NVL (rdie.int_adj, 0)
FROM rb_ac rae, rb_dr rdie, gl_sys gs, fm_gl fgm
WHERE rae.i = rdie.i(+)
AND rae.acct_st <> 'C'
AND gs.int_pa = fgm.gl_code
AND (NVL (rdie.int_accr, 0) + NVL (rdie.int_adj, 0)) <> 0
AND NVL (rdie.no_dr, 'Y') = 'Y'
AND rae.i > 0);
thnks