hi
Firstly, can we please keep this online?
My opinion (observation!)..
in RBO the driving table is the rightmost
in CBO it need not be so..cos the optimizer
decides the order.
can someone confirm the observation regarding
CBO?
Thanx
PS: sorry If i missed this...in some earlier
Anup,
This can get into a lengthy discussion, but I'll try to keep it short. In
general you can use this in both CBO and RBO, since in my experience doing
things well for RBO has no ill affect on CBO.
The table order in the 'from' clause should match the order in the 'where'
clause.