First question is whether you're in Cost Based or Rule Based optimization.
In RBO you are correct that it will read tables right to left unless
instructed otherwise by a hint.
In CBO, Oracle will choose what it thinks is 'best', which most of the time,
but not all of the time :), will be true.
Hi there ,
Thanks for the reply .
I am in Cost Based Optimizer ( we all will be now a days ) .
Does that mean , if I want to know ( or decide ) while writting the query , my
driving table , Its not possible ???
If I have a good idea ( size of data in tables , indexes etc.) about the
tables
Basically, that's correct. Oracle _generally_ does a good job choosing an
excellent execution path. In some cases better than can be achieved through
the Rule-based optimizer...However there's that 0.5% that we have to
manually tune. Check out the section on HINTS in your Oracle Docs...you have
a