Re: SQL Question

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Mon, 12 Oct 1998 11:50:55 +0100
Message-ID: <6vsmtk$m7h$1@schbbs.mot.com>

It will very much depend on your join conditions and the indexes you have (or haven't) defined. Use the EXPLAIN PLAN functionality on individual SQL statements to find out exactly what Oracle does with them.

--
Alan D. Mills

Rajesh M wrote in message <3621cd0c.0_at_news.euroconnect.dk>...
>Hi,
> select t1.col1, t2.col2, t3.col3
> from table1 t1, table2 t2, table3 t3
> where <join_condition>
>
>In which order does Oracle read data - I mean which table is read first. I
>guess the optimizer does a lot of work in a COST based env. How about RULE
>based environment ?
>
>
Received on Mon Oct 12 1998 - 05:50:55 CDT