MySQL Forums
Forum List  »  Full-Text Search

MATCH AGAINST only used in SELECT clause, index necessary?
Posted by: Gary Cornelisse
Date: April 15, 2009 11:59AM

I'm unraveling the mess a previous developer has created for a new client of mine. What I'd like to do is remove the full text index from a table. I don't think its being used by MySQL. It doesn't show up using explain. It would certainly help the efficiency of inserts and updates on this table to remove it.

SELECT
*,
MATCH
(`domurl_title`, `domurl_full_url`, `domurl_keywords`, `domurl_description`, `domurl_synonyms`)
AGAINST
('hello world' IN BOOLEAN MODE) AS `relevancy`
FROM
`domurls`
WHERE
`account_id` = '358863'
AND
`domain_id` = '1282'
AND
`domurl_deleted` = 'no'
HAVING
`relevancy` > 0.2
ORDER BY
`relevancy` DESC;

The index, as defined, is setup to match these fields exactly as how you see them here in this query.

Thanks, Gary

Gary M. Cornelisse
Summit Media Concepts LLC
http://www.SummitMediaConcepts.com



Edited 1 time(s). Last edit at 04/15/2009 12:04PM by Gary Cornelisse.

Options: ReplyQuote


Subject
Views
Written By
Posted
MATCH AGAINST only used in SELECT clause, index necessary?
5984
April 15, 2009 11:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.