MATCH AGAINST only used in SELECT clause, index necessary?

[Gary Cornelisse]

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.