Re: What hint would you try?
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 9 Jun 2011 13:43:36 -0700
Message-ID: <BANLkTinRW_MsVZ6AUYeHNi_Ym6bQyRmYUA_at_mail.gmail.com>
Not knowing what plans you are currently getting makes it next to impossible to guess what hints would be required. Please add the output from
explain plan for
<your query>;
select * from table(dbms_xplan.display(format=>'outline'));
Date: Thu, 9 Jun 2011 13:43:36 -0700
Message-ID: <BANLkTinRW_MsVZ6AUYeHNi_Ym6bQyRmYUA_at_mail.gmail.com>
Not knowing what plans you are currently getting makes it next to impossible to guess what hints would be required. Please add the output from
explain plan for
<your query>;
select * from table(dbms_xplan.display(format=>'outline'));
On Thu, Jun 9, 2011 at 1:28 PM, Ethan Post <post.ethan_at_gmail.com> wrote:
> The first two queries run fast enough. However, when they are joined (third
> query below) on 4 columns which is a solid one to one join it runs really
> slow. I need to force Oracle to resolve each section first and then do the
> join. Which hint should I be focusing on, I have tried quite a few and I am
> not having success.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2011 - 15:43:36 CDT