MySQL Forums
Forum List  »  InnoDB

MySQL full text index doesn't show up in query plan when use with multiple match and related tables
Posted by: Ajith PN
Date: November 30, 2020 06:25AM

explain

select distinct o.id, o1.id, order_items.order_id
from orders o
left join orders o1
on MATCH(o1.po_number)
AGAINST('+test*' IN BOOLEAN MODE)
and o1.id=o.id
left join order_items
on MATCH(order_items.product_description)
AGAINST('+test*' IN BOOLEAN MODE)
and order_items.order_id=o.id
where COALESCE(o1.id, order_items.order_id)is not null

In the above query plan the full text index is not present in the possible keys. Can anyone help with what is wrong here? Thank you.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL full text index doesn't show up in query plan when use with multiple match and related tables
275
November 30, 2020 06:25AM


Sorry, only registered users may post in this forum.

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.