Re: Table Joining Sequence

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: 2000/06/10
Message-ID: <8hu74l$87k$1@nnrp1.deja.com>#1/1

Hi.

You did not specidied join condition ( no WHERE clause ).
Probably Oracle will start from table_c -> table_b -> table_a.
If you want to see what happens - use EXPLAIN.
If you want to specify access order - use ORDERED hint ( or LEADING hint in 8i ).

HTH. Michael.

In article <8htuou$1epc$1_at_adenine.netfront.net>, Norris <jcheong_at_cooper.com.hk> wrote:
> When I issue
>
> select *
> from table_a, table_b, table_c
>
> Which two tables would join first inside Oracle?
>
> --
> http://www.cooper.com.hk
>

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