Difference between ORDERED and LEADING hints
Oracle documents says that, LEADING is more versatile than ORDERED but does not give any rational behind that !
Few blogs say that, ORDERED will not respect TRANSFORMATION and thus it is applied after TRANSFORMATION. Well, i have tested the same and i do agree with that, but i observed the same
behavior with LEADING hint as well. Ie. LEADING hint also ignores transformation.
Can i use any parameter (object name/table name) with ORDERED hint as what i can use with LEADING (EMP,DEPT) ?
Documents also says that if both hints are used together than LEADING will be ignored by ORDERED hint ? Is that true ?