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
898
November 26, 2019 03:43AM
Re: Bad order by performance (5.7.12 under Aurora)
274
November 26, 2019 01:46PM
312
November 26, 2019 02:05PM
323
November 26, 2019 03:29PM
294
November 26, 2019 05:00PM
276
November 27, 2019 02:03AM
327
November 27, 2019 04:21AM
301
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.