Database Tuning (MOSC)

MOSC Banner

Need help improving UPDATE statement

This statement used to run just fine. It updates around 75,000 rows. I'm guessing with the additional indexes to improve the select statements I have slowed down this statement. I need help improving the speed of this update command.


UPDATE TRAPPING_MERGE_EVW 

Set

TRAPPING_MERGE_EVW.needs_inspection = 'Y',

TRAPPING_MERGE_EVW.t_date = NULL,

TRAPPING_MERGE_EVW.wvlcount = 0,

TRAPPING_MERGE_EVW.action = NULL,

TRAPPING_MERGE_EVW.killstrip = '0',

TRAPPING_MERGE_EVW.lure = '0',

TRAPPING_MERGE_EVW.cropstage = '99',

TRAPPING_MERGE_EVW.trapper = '999999',

TRAPPING_MERGE_EVW.sched_insp_concat = schedule||'Y'

WHERE schedule = 'N' and ZONE like '17%'

Tagged:

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