Re: What hint would you try?
From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Thu, 9 Jun 2011 23:54:14 +0300
Message-ID: <BANLkTi=gB2_G8aziibWEuyebRJ_z=Prg_w_at_mail.gmail.com>
if you have something not very old then try:
Date: Thu, 9 Jun 2011 23:54:14 +0300
Message-ID: <BANLkTi=gB2_G8aziibWEuyebRJ_z=Prg_w_at_mail.gmail.com>
if you have something not very old then try:
with a as (SELECT /*+ materialize */ first one here), b as (SELECT /*+ materialize */ second one here) select whatever from a join b on (join expression)
Gints Plivna
http://www.gplivna.eu
2011/6/9 Ethan Post <post.ethan_at_gmail.com>:
> 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 09 2011 - 15:54:14 CDT