MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

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?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Any difference in no-condition-group-by between on partition table and non-partition table?
4361
Ming Lu
April 13, 2011 09:46PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?
1675
Rick James
April 14, 2011 11:45PM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?
1883
Mattias Jonsson
May 02, 2011 02:44AM
Re: Any difference in no-condition-group-by between on partition table and non-partition table?
1890
Ming Lu
June 08, 2011 09:47AM


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.