Re: Optimizing WHERE computations

[Benoit St-Jean]

Craig Matthews wrote:
> Hi,
>
> I know MySQL does not optimize computations in the
> WHERE clauses, e.g.,
>
> SELECT * FROM news
> WHERE time > SUBDATE(NOW(), INTERVAL 1 DAY);
>
> In the above query, what can I do to optimize the
> response time?
>
> Thanks!

If you executing this statement from an application (as opposed to a SQL script), you could calculate he right expression an issue a comparison against a litteral. e.g.

1) Calculate the equivalent of "SUBDATE(NOW(), INTERVAL 1 DAY);"

2)
SELECT *
FROM news
WHERE time > '2005-06-01';