full_text_search indexing problem
Hello ,
I am working on my companys site which is a job portal. In this we have a text serach option which is used to find resumes based on a keyword. The resume is stored in a field in the database. Now as the databse records have increased (about 2 lakhs) the text serach has gone slow. so i plan to shift the query based on 'like ' operator to FULLTEXT . Now for that i would have to create the FULLTEXT index. But the problem with this is ...... if i'll start indexing such a huge database records , it will take hell lot of time ........... So is there a way to minimize this time or is there any other way to increase the speed of my serach.
PLZ HELP.....................
R
Subject
Views
Written By
Posted
full_text_search indexing problem
2996
October 15, 2005 12:57AM
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.