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
11739
December 18, 2004 08:18AM
6327
December 18, 2004 11:18AM
4677
December 21, 2004 08:40AM
Re: FULLTEXT Search performance
4713
December 21, 2004 11:27AM
4446
December 22, 2004 02:02AM
6153
December 22, 2004 07:54AM
4191
December 31, 2004 08:09PM
4084
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.