MySQL Forums
Forum List  »  Full-Text Search

FULLTEXT and INDEXES...
Posted by: James H
Date: October 05, 2008 03:36PM

For this query...

SELECT items.id, manufacturers.name, items.name, items.description, items_tech_info.info
FROM manufacturers, items, items_tech_info
WHERE
( (MATCH(items.name, items.description) AGAINST ('whatever' IN BOOLEAN MODE)) OR (MATCH(manufacturers.name) AGAINST ('whatever' IN BOOLEAN MODE)) )
AND items.manufacturerID = manufacturers.id AND items_tech_info.id = items.id

...what would be the best indexes for me to have on my 'items' table?...
1. PRIMARY(id, name, description) and FULLTEXT(name, description)
or 2. PRIMARY(id) and FULLTEXT(name, description)

...i.e., would using the PRIMARY index to collate the FULLTEXT 'items.name' and 'items.description' fields with the 'items.id' field give any performance improvement over just having 'items.id' as the PRIMARY index?

Thanks,
James

Options: ReplyQuote


Subject
Views
Written By
Posted
FULLTEXT and INDEXES...
4123
October 05, 2008 03:36PM
2892
December 04, 2008 09:12PM


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.