Database Tuning (MOSC)

MOSC Banner

Need Help tuning this query uses 68% of execution time

edited Aug 6, 2009 10:49AM in Database Tuning (MOSC) 5 commentsAnswered
 SELECT r.auto_charge_rule_name,
       r.auto_charge_rule_id,
r.flat_fee_amount,
r.eligibility_condition,
       r.FUNCTION,
r.attribute01 all_instances,
r.attribute02 rule_type,
        csc.csc_id,
csc.charge_sub_type_name,
csc.charge_type_name,
csc.enabled_flag,
        r.attribute03 allow_reversal,
r.attribute04 allow_inelig_rev,
        r.attribute05 eff_date_function,
r.attribute06 apply_matrix,
        csc.attribute03 apply_tax,
r.attribute07 earning_track
        FROM SBS_AUTO_CHARGE_RULES r, SBS_CHARGE_SUB_CHARGE_MAP csc
        WHERE TO_NUMBER (csc.attribute06) = r.auto_charge_rule_id
        AND (r.valid_to IS NULL OR r.valid_to >= SYSDATE)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center