Re: oracle context - performance rel Question ?

Few questions:

1. Configuration? init.ora?
2. What is the size of the indexed column?
3. What is a typical query_string?
4. How many rows are returned in the

    resulttab?

>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
Received on Tue Dec 07 1999 - 18:28:32 CST