Re: FULLTEXT Search performance
Posted by:
James Day
Date: December 21, 2004 11:27AM
alter table papers add index id2 (id);
explain select count(p2.id) from papers, papers as p2 where match(title,keywords) against("test") and p2.id=papers.id;
And see how it compares to the previous result. Add title to the new index if your real query wants the title and you'll end up with a covering index.
No warranty and maybe one of the MySQL employees who reads this will have an alternative and/or better idea.
Subject
Views
Written By
Posted
11656
December 18, 2004 08:18AM
6285
December 18, 2004 11:18AM
4648
December 21, 2004 08:40AM
Re: FULLTEXT Search performance
4683
December 21, 2004 11:27AM
4422
December 22, 2004 02:02AM
6121
December 22, 2004 07:54AM
4158
December 31, 2004 08:09PM
4047
April 15, 2005 08: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.