Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am sure there are some easy ways to do this... I have a simple flat Oracle table which is 13 terabytes or so in size due to a large number of rows accumulating over the years. I need to do a search on it (can be looking for matches on any of a number of fields), and would like to return the most relevant records in a list, like top 50 or top 100 which I can then click on for more detail (will then query specifically one field in that particular record).

What .net or Java - library or package would you recommend for this kind of search in Oracle? Any chance there might be an example open source application or example like that out there that does this exact thing? I am hoping to find something that allows me to prioritize matches in certain columns first, and finds matches quickly despite the large table size, and can easily be integrated into the second part of the requirement which is a regular query based on a "thread" to which that record belongs.

Thank you.

share|improve this question
add comment

1 Answer 1

up vote 1 down vote accepted

There are some useful hints in this SO post.

If you are looking for alternatives to Oracle Text, have a look at this.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.