Yes, it needed indexes, and I am working on that at the same time. They are in place now.

I am also trying to figure out what triggered...

Thanks Paul:

It is ad-hoc--it comes in as a query passed in from the web front end, rather than as a stored proc or the like.

I will try the...