| Sorting Results [message #65834] |
Thu, 06 January 2005 23:56  |
Naveen Kumar
Messages: 7
Registered: August 2004
|
Junior Member |
|
|
Hi All ,
We have a database that consists of approx 40,000 records, and we are suppose to write a search method for it.The searching technique includes finding data on suffixes, prefixes, and in between character combinations e.g. we have data
fenvia
nerufen
asfenas
and now if we have to conduct search on keyword 'fen' then it should return all the three records mentioned above in a
sequence
fenvia // like 'fen*'
nerufen // like '*fen'
asfenas // like '*fen*' minus all above records
(to avoid repetition)
how we can speed up our search technique for such a bulk of data.i.e. 40,000 entries(approx)
Thanks in advance
Naveen Kumar
|
|
|
|
| Re: Sorting Results [message #65835 is a reply to message #65834] |
Fri, 07 January 2005 02:14  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Create an Oracle Text index (INDEXTYPE IS ctxsys.context) and SELECT the data using CONTAINS in the WHERE clause.
See the Oracle Text Reference Guide for details.
If you have more questions, post them on the Oracle Text forum.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
