Re: Bad order by performance (5.7.12 under Aurora)
Ciao Nicola,
the temp table might not involve slowness, it depends if it goes to disk or not.
However it might be good to have also the tables definitions too.
I also recommend you to try MySQL 8 where you can benefit from many optimizer improvements.
We also have now explain format=tree and explain analyze !
Regards,
Subject
Views
Written By
Posted
638
November 26, 2019 03:43AM
Re: Bad order by performance (5.7.12 under Aurora)
193
November 26, 2019 01:46PM
210
November 26, 2019 02:05PM
238
November 26, 2019 03:29PM
206
November 26, 2019 05:00PM
192
November 27, 2019 02:03AM
228
November 27, 2019 04:21AM
213
November 27, 2019 05:46AM
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.