MySQL Forums
Forum List  »  InnoDB

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

Hi,

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

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

Thanks,
Ranala

Options: ReplyQuote


Subject
Views
Written By
Posted
performance issue even i have index on my columns
801
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.