|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: help wit query optimization (cont'd)
From: Sebastian Mendel (lists
sebastianmendel.de)
Date: Wed Jan 09 2008 - 07:34:59 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Perrin Harkins schrieb:
> On Jan 9, 2008 4:33 AM, Sebastian Mendel <listssebastianmendel.de> wrote:
>> usually ... but i do not know of any index capable of having FULLTEXT and
>> 'normal' fields in one index
>
> Does that matter?
yes, as written in the mentioned article the test is only relevant with
correct used indexes, but MySQL does not use more than one index, so this
query cannot all be done with indexes
please correct me if i am wrong
--
Sebastian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]