Greetings Set,
Set you are truly an asset to this list and in my book rank at the top of the
list with Helen and Mark. I have learned so much from you three in the last
few months. I of course do not discount any others that send out helpful
replies as I can learn from all (Trust me).
Anyway, I have modified my stored procedure to implement your suggestion:
Then I'd expect a small improvement if you generally changed to
AND PP.STATUS_CODE||'' IN ('G','V')
and
ORDER BY PP.STATUS_CODE||''
It went from 2 hours and 45 minutes down to … get this … under 12 minutes. WOW
Thanks so much for all that have replied.
Mike
