SQL Question
From: Rajesh M <raju_m_at_hotmail.com>
Date: 1998/10/12
Message-ID: <3621cd0c.0_at_news.euroconnect.dk>#1/1
Date: 1998/10/12
Message-ID: <3621cd0c.0_at_news.euroconnect.dk>#1/1
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 ?
Thanks a lot
Rajesh Received on Mon Oct 12 1998 - 00:00:00 CEST