Database Tuning (MOSC)

MOSC Banner

Explain plan with high Network Cost

edited Jul 23, 2010 4:48AM in Database Tuning (MOSC) 9 commentsAnswered
 Hi,
We have the next SQL:

select count (distinct(ef.fli_id)) AS num
FROM pp_fls_inf ef
JOIN pp_perss per ON ef.registro_per_id = per.per_id
JOIN pp_proff pro ON per.per_id=pro.per_id
LEFT OUTER JOIN pp_fli_tpr flt ON ef.fli_id = flt.fli_id
LEFT OUTER JOIN pp_tip_proff tpr ON flt.tpr_id=tpr.tpr_id
JOIN stk_niveles nvs on ((ef.nv1_id = nvs.nv1_id
        AND ef.nv2_id IS NULL
        AND ef.nv3_id IS NULL
        AND ef.nv4_id IS NULL)
    OR (ef.nv1_id = nvs.nv1_id

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