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
11559
December 18, 2004 08:18AM
6230
December 18, 2004 11:18AM
4615
December 21, 2004 08:40AM
Re: FULLTEXT Search performance
4639
December 21, 2004 11:27AM
4386
December 22, 2004 02:02AM
6077
December 22, 2004 07:54AM
4122
December 31, 2004 08:09PM
4004
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.