SQL Performance (MOSC)

MOSC Banner

Order of join/filter conditions vs Optimizer 11gR2

edited May 23, 2013 5:26AM in SQL Performance (MOSC) 6 commentsAnswered ✓
Hi ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center