lists.zerezo.com
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

***BOGO*** Re: Slow Query

At 10:07 AM 6/27/2008, you wrote:

Hi Ananda,

The query is for reporting purposes and I would like to include a date range
for the user to report on. That part of the query has to be there for it to
work nicely.

Regards,
Darryl


Darryl,
Your Where Clause uses a date expression on the column so it has to scan all the rows that satisfies the date range.
Mike 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx