MySQL Forums
Forum List  »  Optimizer & Parser

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Explain command type "All" issue
720
February 14, 2020 03:20AM
398
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.