Re: Please help to debug strange execution plan
Date: Thu, 5 Jun 2008 11:48:38 -0700
On Thu, Jun 5, 2008 at 2:53 AM, Michael Seiwert <mseiwert_at_hbv.de> wrote:
> Hi List,
> I have two identical queries which differ only in the search term of the
> contains clause. Both queries produce completely different execution plans
> and execution times.
> If I run the the following query with searchterm 'spartacus' in the
> contains clause the query executes within 2 seconds, if I run the same
> query with searchterm 'tatort' the query returns in about 20 minutes. Please
> see the attached explain plans for details. Could you please help me to
> debug this as I want to understand why oracle behaves how it behaves :-)
> I'll could provide more information such as view definition, 10046, 10053
> traces if needed.
The spartacus query is using the domain index (CTX) while the tatort query is not.
Don't know if you noticed that bit or not, you didn't mention.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 05 2008 - 13:48:38 CDT