Re: [SQL] JOIN performance

[Dean Gibson (DB Administrator)]

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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]