MySQL Forums
Forum List  »  Optimizer & Parser

Re: Explain command type "All" issue
Posted by: Peter Brawley
Date: February 14, 2020 10:28AM

We'll need to see MySQL version, amount of RAM, OS, the query, the result of Show Create Table for each table referenced by the query, the result (inside BBCode code tags) of running Explain on the query, if Mysql version=8.0 then also the results of Explain Analyze and Explain Format=Tree on the query,



Edited 1 time(s). Last edit at 02/14/2020 06:39PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
719
February 14, 2020 03:20AM
Re: Explain command type "All" issue
397
February 14, 2020 10:28AM
388
February 14, 2020 05:52PM


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.