Re: Query does not use index
For human readability, Explain results show best here when they've been copied & pasted from the mysql client program then surrounded by BBCode code tags. When the query is big or complex, and for format=JSON, terminate the cmd with \G instead of a semicolon.
Is there a performance issue? As I read this Explain result, the optimiser proposes to build index auto_key0 key_len=16 for the subquery. To find what that key is, try running Explain with format=JSON.
Subject
Written By
Posted
February 02, 2022 04:48PM
Re: Query does not use index
February 03, 2022 11:57AM
February 03, 2022 04:31PM
February 03, 2022 04:54PM
February 03, 2022 05:17PM
February 03, 2022 05:40PM
February 03, 2022 08:11PM
February 04, 2022 09:38AM
February 04, 2022 11:03AM
February 04, 2022 05:18AM
February 04, 2022 09:29AM
February 04, 2022 09:35AM
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.