It turns out that even when I removed the CASE statement from the VIEW, the
performance problem remained. I had to remove the conditional as well from
the VIEW.
To refresh your memory, there was this line in the VIEW (said VIEW being
the subject of the LEFT JOIN):
cancel_date < expire_date AS canceled,
(cancel_date & expire_date are DATEs in the base view)
When I removed the above line from the VIEW, the performance problem
disappeared.
Do you know why? I'm running 7.3.4, by the way.
-- Dean
