Hi Brent,
That's the ticket! I swapped SYSDATE out for NOW.
Thanks to the two of you!!!
Mike
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: March 12, 2007 3:50 PM
To: Little, Timothy; Caplan, Michael; mysql@lists.mysql.com
Subject: Re: Function in
dex_1 instead of Index_4
Any other ideas?
Thanks!
Mike
-Original Message-
From: Little, Timothy [mailto:[EMAIL PROTECTED]
Sent: March 12, 2007 3:38 PM
To: Caplan, Michael; mysql@lists.mysql.com
Subject: RE: Function in Query has Terrible Impact on Indexes Used
My guess, without see
Hi There,
I'm having terrible results with a query that uses functions to define
dynamically conditions in the WHERE clause. However, if I change the
query to not use these functions, the query flies because it uses proper
indexes.
The query without functions is as follows:
SELECT
