Re: Using Optimizer Hints

in reply to Using Optimizer Hints

Why not? It's part of the statement.

whether the hints are used by the Oracle Optimzer

Whether Oracle will honor or ignore a hint is an Oracle question, not a Perl one.

As a side note, hints "are the path of last resort."

Comment on Re: Using Optimizer Hints

Replies are listed 'Best First'.
Re^2: Using Optimizer Hints by sen (Hermit) on Jul 24, 2015 at 13:39 UTC
Thanks for the reply. But its not picked by the Oracle Optimizer when its executed through perl.	[reply]
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

In Section Seekers of Perl Wisdom