Home » RDBMS Server » Performance Tuning » Sorting Results
Sorting Results [message #65834] Thu, 06 January 2005 23:56 Go to next message
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 Go to previous message
Frank Naude
Messages: 4565
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
Previous Topic: when database is full
Next Topic: how to connect with oracle database
Goto Forum:
  


Current Time: Wed Sep 30 11:17:30 CDT 2020