aggregation in mysql
Hello there!
my question is related to the way mysql optmizes aggregate/group-by queries. Very conventional systems usually perform the evaluation of all joins in the query and then apply on the resulting table the requested aggregation(s)/group-by. However, one can easily perform smarter methods, e.g., in many cases multiple "early" aggregations can be used to reduce the size of intermediate relations as well as to count the overall number of tuples needed to solve a particular aggregate. What about mysql? Which kind of optimization for aggregation is provided?
Thank you,
have a nice day.
Luca.
Subject
Views
Written By
Posted
aggregation in mysql
3186
February 27, 2010 11:03AM
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.