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 <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
