MySQL Forums
Forum List  »  Partitioning

Re: Any difference in no-condition-group-by between on partition table and non-partition table?
Posted by: Rick James
Date: April 14, 2011 11:45PM

I don't know for sure, but I would expect PARTITION and non-PARTITION and MERGE to behave essentially the same way -- full table scan + sort + group by.

There are cases where it might act differently. An example: if there is a covering index.

Mattias, comments?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Any difference in no-condition-group-by between on partition table and non-partition table?
1672
April 14, 2011 11:45PM


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.