Full-Text search with join to keyword table
I have a large inventory file with a fulltext index on the description field. I also have a keyword table with numerous description keywords. I am looking for a fast way to return any records in the inventory file where the description matches against any keyword in the keyword file and we have stock?
The query below does what I am looking for but it is very slow.. is there a way to use a fulltext match against in the join that would speed up the query?
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
SELECT
p.partno, p.ohqty, p.descriptio , k.key2
FROM
parts p
INNER JOIN keywords2 k ON p.descriptio LIKE CONCAT('%',k.key2,'%')
where ohqty > 0
order by key2
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Subject
Views
Written By
Posted
Full-Text search with join to keyword table
2078
September 29, 2017 07:36AM
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.