SQL Performance (MOSC)

MOSC Banner

Update is slow

edited Nov 23, 2013 8:41AM in SQL Performance (MOSC) 4 commentsAnswered
 Hi,
The following query takes more than 50 mins to update 8000 rows,it has index on all the columns  in the query,but however it does full table scan in ECG_STUDY...any idea in rewriting this query,

Tuning advisor has no recommendatins for this query ,..,the version is 11.2.0.,3

UPDATE ecg_study es

   SET es.r_mc_ecg_confirm_status =

       (SELECT DECODE(ps.ps_ecg_confirm_type,

                      NULL,

                      173,

                      DECODE(ps.ps_ecg_confirm_type, 168, 172, 173))

          FROM /*ecg_study es,*/ protocol_study ps

         WHERE es.ps_protocol_id = ps.ps_protocol_id(+)

           AND es.r_mc_ecg_confirm_status NOT IN (172, 173, 174))


-Thanks

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