Indeed - the missing hint info was indeed, e.g.: ... $emp.fname /*+ skip-index */ >= "Max" ...

(Our hints are essentially "optimizer interpreted comments" that start with a + to get its attention; it ignores hints it doesn't understand or that do not apply, so it's good to verify that they're taken by looking at the resulting plans.)


On 5/30/16 10:11 PM, Taewoo Kim wrote:
  $emp.fname /*+ skip-index */ >= "Max"

Reply via email to