Re: SQL tuning question.

Michael, thanks for responding to my question. I understand that the possible solution would be to go with partitioning.

Already started looking into that :)

Thanks again,
-Jibo

>Sounds like your hitting the scalability barrier for context searches,
>whatever that may be. I am assuming you've looked into parallel settings
>for the table, and that your SGA is sized adequately to handle the many
>data blocks returned by such queries. We have seen marked improvements in
>these types of queries by implementing partitioning of large or quick
>growing tables. Especially when you can partition by a date/time column.
>
>Of course, the other possibility is to create a column based upon the
>common strings your sample queries below seem to be referencing
>(version). Of course, I realize, especially with purchased software, this
>might be impossible.
>
>Good luck and let me know if you try partitioning!

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jibo John
  INET: jijohn_at_cisco.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).