SQL Question

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 - 04:34:17 CDT