Invalid Hints are Silently Ignored? An Invalid USE_HASH Hint Transforms a Sort-Merge Join into a Nested Loops Join

(Charles Hooper) How many times have you heard or read that the Oracle Database query optimizer may freely ignore hints if it so chooses? How many times have you heard or read that the query optimizer silently ignores hints that are invalid? I was recently reminded of both of these concepts while

Read More - Register for Free Membership