in reply to Re^3: Using Optimizer Hints
in thread Using Optimizer Hints

Yes, when i executed it direclty, the oracle optimizer uses the hint.

Replies are listed 'Best First'.
Re^5: Using Optimizer Hints
by chacham (Prior) on Jul 24, 2015 at 14:32 UTC

    I just want to be clear here. You are using it with a host variable in Oracle? That will match the prepare with a ?. For example:

    VAR Name VARCHAR2

EXPLAIN PLAN FOR SELECT /*+ index(a index1) */ name, age FROM people a
+ WHERE name LIKE :Name;

    [download]

    Also, how are you verifying if the hint is being honored?

    Update: Related: Where the advice to use DBI bind parameters can go wrong (long)
[reply]
[d/l]

In Section Seekers of Perl Wisdom