MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Sergei Golubchik Date:September 10 2003 2:03pm
Subject:Re: Suboptimal index-usage with FULLTEXT-search
View as plain text  
Hi!

On Sep 10, Tobias Lind wrote:
> Hi!
> I'm running a large web application with MySQL 4.0.14.
> The application is performing searches in a large table (>500.000 rows).
> The WHERE-clause for these searches sometimes is a combination of different
> columns in the table, and I have noticed some very sub-optimal index-usage
> when the search includes a FULLTEXT-indexed column. MySQL seems to ALWAYS
> use the fulltext-index in these searches - even if, for instance the
> PRIMARY-index would be far more optimal.

Adding correct estimations for MATCH is in todo.
Until it's done you can use USE_INDEX/IGNORE_INDEX as a simple workaround.
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com
Thread
Suboptimal index-usage with FULLTEXT-searchTobias Lind10 Sep
  • Re: Suboptimal index-usage with FULLTEXT-searchSergei Golubchik10 Sep
Re: Suboptimal index-usage with FULLTEXT-searchSteven Roussey17 Sep