Re: FULLTEXT indexes and MATCH not giving hoped for results
Posted by:
Rick James
Date: April 10, 2014 02:28PM
> AGAINST ('*foo*' IN BOOLEAN MODE)
The leading "*" virtually eliminates the utility of FULLTEXT. Can you avoid it? If you can't, you may as well use LIKE and not FULLTEXT.
What is the FULTEXT index declared as? One index with 10 fields? 10 1-field FULLTEXT indexes?
Are you using MyISAM or InnoDB?
Notice how many of these questions would be already answered if you have provided the _actual_
SHOW CREATE TABLE
SELECT
EXPLAIN SELECT
Please provide those now.
Subject
Views
Written By
Posted
1398
April 09, 2014 08:55AM
Re: FULLTEXT indexes and MATCH not giving hoped for results
815
April 10, 2014 02:28PM
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.