Re: Table Joining Sequence

It seems that my Oracle can't do this. I found the if I put the empty table at the end of FROM clause, the query can speed up a lot of time.

fangliu_at_my-deja.com wrote:
> Hi, Norris:
 

> It depends on the optimizaiton stratagy. Most DBMSs have their own
> aptimizaiton algorithms, and they will re-order the join sequence when
> the sql is executed. So, you need not take care too much of this
> problem.

> Sent via Deja.com http://www.deja.com/
> Before you buy.

-- 
http://www.cooper.com.hk