I’m a new mysql developer, just started working on performance.
I have large table as 50 mln rec for now ( still growing).
This is a fact table.
I execute the statement in my stored proc :
create temporary table tt as
SELECT SrcUserGroupID, SrcReportObjectID,
Action, SUM(Counter) as Counter
where DataSourceID=2 and Datex between ‘2009-02-23 20:00:00’ and ‘2009-02-24 19:00:00’
group by SrcUserGroupID,SrcReportObjectID,DestReportObjectID, FirewallRuleID,RootCauseID,ServiceID, Action
I’m not sure how to tune Group By,
I even created an index on all Group By fields and made the order in select the same, but this index is not used.
from status - I’m not using disk temp tables.
what else could I check?
I do have have an index on Datex,DataSourceID.