I need to optimise:
SELECT * FROM table WHERE MATCH(text_field) AGAINST (‘text’) ORDER BY score DESC;
where score is a pre-computed int field.
At the moment, despite text_field and score both having indices, the query results in a filescan.
I guess as mysql will only use one index per table, it is using the fulltext index.
Is there anything that can be done to speed this up?