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%'