Re^2: Using Optimizer Hints

Replies are listed 'Best First'.
Re^3: Using Optimizer Hints by chacham (Prior) on Jul 24, 2015 at 14:17 UTC
When you run it directly in Oracle, is the hint used? That is, with a host variable.	[reply]
Re^4: Using Optimizer Hints by sen (Hermit) on Jul 24, 2015 at 14:29 UTC
Yes, when i executed it direclty, the oracle optimizer uses the hint.	[reply]
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]