Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...
The real fact of the matter is the OP says it used to work just fine... and doesn't now... what could be the problem? Parallelism?
--Jeff Moden
Change is inevitable... Change for the better is not.