Message-ID: <840CC2221F934911BC8685C1400C7A7C@Primary>
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
To: "Oracle L" <oracle-l@freelists.org>
References: <D18D6513433DF04394041EA42B53E91C57884719@ICATEXCH2.ICAT.com> <4E69BFBE.6000803@roughsea.com>
Subject: Re: getting in a little over my head
Date: Fri, 9 Sep 2011 09:17:24 +0100
MIME-Version: 1.0
Content-type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: jonathan@jlcomp.demon.co.uk


Stephane,

It depends on the uniqueness constraints, of course, but I think (based on the 
information we have so far)
that the "UNION ALL" should be a "UNION".

FROM (select objectid objid, 'Quote' linktype
       FROM quote
       WHERE accountid = 128847
       union all
       select objectid objid, 'Policy' linktype
       FROM pol_policy
       WHERE accountid = 128847
         AND logid = 1) x

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com


----- Original Message ----- 
From: "Stephane Faroult" <sfaroult@roughsea.com>
To: <JSweetser@icat.com>
Cc: "Oracle L" <oracle-l@freelists.org>
Sent: Friday, September 09, 2011 8:26 AM
Subject: Re: getting in a little over my head


Joe,
     I have never been a great fan of execution plans but I have always
hated multiple subqueries that kind of "sequentialize" everything. For
me, everything depends in your query about the selectivity of accountid
in tables quote and pol_policy, and my gut instinct would make me
rewrite your query like this:


--
http://www.freelists.org/webpage/oracle-l