hy,

in a 'where' clause ,
the order of join condition is important
or not for performance (in mode= choose or mose =rule)?
And so, how to know the best order (first big table ? or not ?,...)


f.e. :

...where
a.col1 = b.clo1 and
b.col1 = c.col1

is it really the same of :

...where
b.col1 = c.col1
a.col1 = b.clo1 and
or
...where
c.col1 = b.col1
a.col1 = b.clo1 and

or ...?

What about the explain plan in these cases ? is it, all the time , the same ?


thanks in advance