G'day Arjen > FULLTEXT search generally uses an index (the FULLTEXT index), so the > server will not use an index on Writer. > So far for the answer to Kim. €€€€ So is an index on Writers worthless in this circumstance? My concern would be if someone did a query using the writer's name as the _only_ criteria. Would this not be inefficient if it's not indexed for a search on several hundred thousand rows?
> There are situations where the optimiser will not use a fulltext index: > 2) if the MATCH is part of an expression. > Therefore, > effectively, two indexes can/will be used! ;-) €€€€ My newbie mind spins a little faster:) I think I understand what you're saying but I think I need further explanation of "the MATCH is part of an expression". Could you perhaps offer an example? Does all of this only apply to mysql 4.x where the 'in boolean mode' is available? Cheers and thanks kim query, sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
