MySQL Forums
Forum List  »  Performance

Re: how could this be?
Posted by: Nathan Cheng
Date: November 21, 2004 04:16PM

Thanks, Sergey, that's perfect.

I still think something should be done about the mere presence of LIMIT being able to completely throw off the join optimizer. The join optimizer should be hardwired to treat a statement with both ORDER BY and LIMIT clauses the same as the statement with just the ORDER BY clause, the reason being that when ORDER BY is present, in the general case, there is no way to use LIMIT to short-circuit the query (whereas when ORDER BY is absent, you could quit the query earlier as soon as you have enough rows to satisfy the LIMIT clause).

Thanks,

Nathan

Options: ReplyQuote


Subject
Views
Written By
Posted
3219
November 20, 2004 01:58PM
2300
November 21, 2004 02:33AM
2229
November 21, 2004 04:04PM
Re: how could this be?
2294
November 21, 2004 04:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.