oracle context - performance rel Question ?

I need help in optimizing a oracle context search. I am new to the product and don't know where to tune to improve the response time of the search.

Right now, two step search takes around 3 minutes to retrive records based on a key work from a table of 10 million rows. We have a policy and associated indexes created on the table.column. We are using two step query to search, retrieve the details and are using forms 5.0 as client to display the results on the screen. After a thorough investigation, i found out that ctx_query.contains(policy_name, query_string, resulttab, sharelevel) part of the step which populates the result table with the relavant records for query_string is taking considerable amount of time like 2 3/4 minutes and rest is done in 15 secs.

Any suggestions on how i can improve the performance, where do i tune ? what do i modify ? etc

your suggestions are highly appreciated!

thanx in advance.

Subu

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 14:18:28 CST