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
1491
November 26, 2019 03:43AM
Re: Bad order by performance (5.7.12 under Aurora)
437
November 26, 2019 01:46PM
544
November 26, 2019 02:05PM
535
November 26, 2019 03:29PM
503
November 26, 2019 05:00PM
492
November 27, 2019 02:03AM
526
November 27, 2019 04:21AM
479
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.