Re: [HACKERS] What about LIMIT in SELECT ?

> Whereas with the SELECT...LIMIT paradigm, the database engine does NOT
> process the entire huge query, it quits processing once it reaches the
> limit.  (Well, at least MySQL does so, if you happen to be using an
> "ORDER BY" supported by an index). Obviously doing 1/4th the work four times
> is better than doing the whole tamale four times :-}.   

And no join, I assume.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026