FULLTEXT and INDEXES...

[James H]

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