MySQL Forums
Forum List  »  InnoDB

performance issue even i have index on my columns
Posted by: Ra Nala
Date: December 16, 2017 11:02AM


i am facing performance issue while i am running the below query in environment as MySQL 5.7.11 InnoDb DB. I am having indexes on joined and groouped columns
columns (i.e. id and date).

is performance issue causes when i apply group up even though i have index in that ?, could you please help on this

, type
, code
FROM temp pd
join (select, max( as lastdate FROM temp p group by z
on = and < z.lastdate


Options: ReplyQuote

Written By
performance issue even i have index on my columns
December 16, 2017 11:02AM

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.