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
Subject
Views
Written By
Posted
performance issue even i have index on my columns
801
December 16, 2017 11:02AM
437
December 16, 2017 01:37PM
478
December 17, 2017 10:29AM
388
December 17, 2017 11:37AM
462
December 18, 2017 12:09AM
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.