Re: Bad order by performance (5.7.12 under Aurora)
Thanks. I think the index would need to be (id,ultima_elaborazione) to be usable.
Left Joins tend to force full table scans so they make for performance trouble. Some of them look to me as if they might be behaving like Inner Joins, others look translatable to Semi-joins, but I'd need a bit of example data to test that out, and to try 8.0 optimisations.
What does the first row of Explain say without the Order By clause?
On 5.7 the query cache is deprecated but still available. If it's on, it may be hiding worse performance, to find out, turn it off (in 8.0 it's removed).
Edited 1 time(s). Last edit at 11/26/2019 05:01PM by Peter Brawley.
Subject
Views
Written By
Posted
1491
November 26, 2019 03:43AM
437
November 26, 2019 01:46PM
544
November 26, 2019 02:05PM
535
November 26, 2019 03:29PM
Re: Bad order by performance (5.7.12 under Aurora)
502
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.