I've had similar issues to this where data growth on the system caused a previously high performing query to become very slow.  On investigation I found that it was doing...