Adam
Thank you for the suggestions Your assumptions are correct. Medical
Facility is < 50 and Patients > 80k.
Using your example, the SP now runs in a few hundred milliseconds. I
have not yet defined any indexes.