Optimising from subqueries to only pull back the relavent table

From: <a_p_day_at_my-deja.com>
Date: 2000/06/23
Message-ID: <8iv89o$43u$1@nnrp2.deja.com>#1/1

Does anybody know if there is a way to get Oracle to take a querysomething like...

  Select * from
  MasterTable, Table2, ...,
   (Select MasterID as SQLink, Sum(Price) as Cost     from DetailTable
    Group By MasterID)

where {condition list}
and SQLink (+)= MasterTable.ID

and delay it's execution of the subquery such that it will not work out the sum till after the main conditions have been evaluated.

Currently I have a system of calculated fields which is pretty fast for unrestrictive queries on the data but unfortuantely doesn't really gain any speed when restrictions are applied.

I realise that the above query could probably be rewritten, but some of the more involved examples would be far more difficult to do generally.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 23 2000 - 00:00:00 CDT