Re: Urgent Tuning Question....

From: Jagjeet Singh <jagjeet.malhi_at_gmail.com>
Date: 14 May 2006 00:16:31 -0700
Message-ID: <1147590991.905905.23800@y43g2000cwc.googlegroups.com>

Hi,

Are you sure .. join is correct..

 where   js.jsu_journal_code     = v_journal_code
and     js.jsu_start_date            < p_start
and             rt.jsu_rate          = rt.rty_code(+)
and             jsu_payment_code     = pm.payment_code
and         pm.real_payment_code    = '1';

you are joining the rt table with itself. Is this table has no link with tables.

You have not told us about the expected no. of records.

If it is less then remove rt table from join and use a co-related sub-query.

Regards,
Js Received on Sun May 14 2006 - 02:16:31 CDT