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