SQL Performance (MOSC)

MOSC Banner

Different explain plans for the same query. Why?

edited May 9, 2014 3:00AM in SQL Performance (MOSC) 2 commentsAnswered ✓

Hello to all,

i´m facing two different explain plans for the same simple query in Production environment and Development environment. I would like like to know, if possible, the reasons the explain plans are differents. Initially the explain plan for both Production and Development was the same. Nothing has changed in Production.

The query is:

    SELECT

      presc_m.idprescripcion,

      MAX(aut_m.COD_ORDEN_AUTORIZACION_PRESC) max_cod_aut

    FROM

      vis_presc_autorizaciones aut_m,

      vis_prescripcion presc_m

    WHERE

      aut_m.idprescripcion = presc_m.idprescripcion

    GROUP BY

      presc_m.idprescripcion;

Table "presc_m" has an index PK on (idprescripcion).

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