Filter predicates with NVL on mandatory columns using the index

(Rob van Wijk) Last Friday at work, I overheard a conversation between two DBA’s about a performance problem of a job which usually ran in 10 minutes, now taking more than 4 hours. I helped them pinpoint the problem: a simple SQL query which took >95% of the time.

Read More – Register for a Membership/membership]
Read More (Community content)