|
|
|
|
Re: sql need tuning - high cpu_time and buffer gets [message #665182 is a reply to message #665178] |
Thu, 24 August 2017 09:28 |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It's anti-join - equivalent to not exists:
AND NOT EXISTS (SELECT 1
FROM xps.prior_sched s
JOIN xps.priority_schedule_unit o
ON (s.id = o.prior_schedule_id)
WHERE SYSDATE BETWEEN s.SCHEDULE_FROM AND s.SCHEDULE_TO
AND priority_level = -1
AND a.order_office_code LIKE o.UNIT_CODE || '%'
)
|
|
|
|