Re: LIMIT clause optimization

Am Dienstag, 7. Januar 2003 12:47 schrieb Felipe Schnack:
>   I was wondering... (a newbie starting to understand how to optimize
> queries)
>   In which step of query execution the LIMIT clause is executed? I mean
> I have a query that would return, let's say, 6 rows, but I add a "LIMIT
> 1" in the end of it.
>   I would speed up things because I would have less data fetching from
> the database, right?

Limit kicks in quite late as it has to be done after sorting. And it is not
recommended to use LIMIT without ORDER BY.

With kind regards / mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter                          http://www.klawitter.de
lists@klawitter.de