> > 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
>
> Adding correct estimations for MATCH is in todo.
> Until it's done you can use USE_INDEX/IGNORE_INDEX as a simple
> workaround.
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
