Now that this has made it through testing and pushed out to production I'll give you the results. Adding the LOOP join hint to each of the RIGHT JOINS...
I am sorry to hear of your data loss. It is standard operating procedure at my company to always take a backup of any database, live or test, before...
GilaMonster, attached are the execution plans for both queries. The main difference between the two is with index seeks changing to scans for tblPolicy...