Home » Server Options » Text & interMedia » Oracle Text Search Performance issue with frequent words
Oracle Text Search Performance issue with frequent words [message #622930] Tue, 02 September 2014 03:00 Go to previous message
Messages: 5
Registered: June 2014
Location: Bangalore
Junior Member

We are using the oracle text search with Context index and contains function in the query. But when we search for the keywords which occur so frequently is taking more time to give the results. But if we execute the query with same words second time it is performing well.
We are using the query template and progression with sequence to order the results.
We are using, FIRST_ROWS hint in the query, gathering stats on the table. Query is getting generated dynamically based on the user input to say in which columns the input words have to be found, so it is little tough for us to use bind variables in the query. But ready to add the bind the variables if it improves the performance so much.

Please let me know whether we can do some additional configuration to improve the performance.

More info:
We refresh the data in search table with some frequency like thrice a day using a scheduled procedure. So is it good to execute some queries with frequent words so that those words get cached in the DB or will be used while deciding the execution plan.

Thanks In advance for your help.

Read Message
Read Message
Read Message
Previous Topic: like performance than CATSEARCH Performance incase of wild character
Next Topic: Index creation performance problem with LOB/CLOB content
Goto Forum:

Current Time: Tue Sep 29 00:41:52 CDT 2020