Re: Oracle Join Optimization

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 23 Nov 2000 15:27:33 -0000
Message-ID: <8vjd15$b9s$1@soap.pipex.net>

With an appropriate index on table1.field1 then the execution plan will be optimal.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
<geenstones_at_my-deja.com> wrote in message
news:8vhb8e$7gf$1_at_nnrp1.deja.com...


> Can I get oracle to only scan the results

> of a joined query?

> Example:

>

> Select * from table1,table2

> where table1.id = table2.id and

> table1.field1 = 'test'

>

> In this query, Oracle is doing a full scan on

> table1 to find 'test'. After the scan is over,

> it will then do the join.

>

> I really want it to only find 'test' on the

> resulting records of the join.

>

> Hope this make sense.

>

> -G

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Thu Nov 23 2000 - 09:27:33 CST