MySQL Forums
Forum List  »  Knowledge Base

Will Mysql avoid full table scan in a GROUP BY query with LIMIT
Posted by: Itay Moav
Date: April 14, 2009 08:38AM

Will Mysql avoid full table scan in a GROUP BY query with LIMIT
where the GROUP BY key is a UNIQUE field.

Do you need a Q/A site for FREE! Check my open source project http://phpancake.sourceforge.net
Watch movies at http://rainofmovies.awardspace.info

Options: ReplyQuote


Subject
Views
Written By
Posted
Will Mysql avoid full table scan in a GROUP BY query with LIMIT
3392
April 14, 2009 08:38AM


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.