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

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;

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)