Order of join/filter conditions vs Optimizer 11gR2
In the following request which the best order of the 4 following conditions of joint / filter with respect to the optimizer 11gR2 ?
Best regards .
GD.
SELECT ... from T1,T2,T3
where
T1.satus= 'A' - condition 1
and T1.id = T2.id - condition 2
and T1.id = T3.id - condition 3
and T2.condition = T3.condition - condition 4