Re^2: Using Optimizer Hints


Come for the quick hacks, stay for the epiphanies.
	PerlMonks

by sen (Hermit)

on Jul 24, 2015 at 13:39 UTC ( [id://1136167]=note: print w/replies, xml )

Need Help??

Thanks for the reply. But its not picked by the Oracle Optimizer when its executed through perl.

Comment on 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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://1136167]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others musing on the Monastery: (3)

As of 2024-04-19 21:03 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found