I'm working with a vendor's system that has a very severe performance problem. I'm looking at it because despite the fact that I told the vendor there was a problem with a particular query back in OCTOBER and that the problem was going to degrade linearly with the data size they didn't (1) fix the query or (2) provide us with a data archive system, and now it's an emergency.
Sigh.
The reason the query is performing badly is that it's a query of a view. Not a stored procedure containing a query of a view even, but their application directly...