Some of your Nvl() functions are redundant.
nvl(sol.schedule_status_code , 'N' ) = 'Y'
... is the same as ...
sol.schedule_status_code = 'Y'
|
Results 1 to 5 of 5
Thread: Query tuning with large data set
Threaded View
|
Click Here to Expand Forum to Full Width |
Reply With Quote