Re: FULLTEXT Search performance
How large is your data file ? Also what is the system load during the query - is it CPU bound or Disk bound ?
One of the things - you could try using MATCH IN BOOLEAN MODE which is often much faster than "natural language search".
Subject
Views
Written By
Posted
12008
December 18, 2004 08:18AM
6461
December 18, 2004 11:18AM
4775
December 21, 2004 08:40AM
4866
December 21, 2004 11:27AM
4564
December 22, 2004 02:02AM
6260
December 22, 2004 07:54AM
Re: FULLTEXT Search performance
4310
December 31, 2004 08:09PM
4200
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.