Explain command type "All" issue
Posted by:
Vipin PA
Date: February 14, 2020 03:20AM
Hi All,
I have a JOIN query that joining 5 tables. I have added indexes for all the fields that are using in the where clause. When I executed the EXPLAIN command for MySql, I got the first line like below.
id : 1
select_type : SIMPLE
table : td
type : ALL
possible_keys : expires_on,record_type
key : NULL
key_len : NULL
ref : NULL
rows : 3063
filtered : 38.49
Extra : Using where; Using temporary; Using filesort
I know type: All is not good.
Can anyone help me to change the type: All to other types like ref, etc?
Please let me know if you need any further information.
Thanks
Vipin
Subject
Views
Written By
Posted
Explain command type "All" issue
870
February 14, 2020 03:20AM
487
February 14, 2020 10:28AM
480
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.