AIL PROTECTED]>;
Sent: Monday, March 12, 2007 2:38 PM
Subject: RE: Function in Query has Terrible Impact on Indexes Used
My guess, without seeing your database CREATE TABLE statement for this
particular table would be that the DATE_FORMAT returns a
string, while the LAST_DAY function returns a
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
h 12, 2007 1:12 PM
To: mysql@lists.mysql.com
Subject: WOW: Function in Query has Terrible Impact on Indexes Used
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
/TIME then use a STR_TO_DATE around the Date_Format
to see if it makes a difference.
Just my humble guess.
Tim...
-Original Message-
From: Caplan, Michael [mailto:[EMAIL PROTECTED]
Sent: Monday, March 12, 2007 1:12 PM
To: mysql@lists.mysql.com
Subject: WOW: Function in Query has Terrible
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
