is it possible to manufacture a query plan.

From: Dustin Hayden <DHayden@xxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 23 Feb 2012 15:25:12 +0000

I have a query that can't be modified. It is a vendor supplied query.
Since I can't change the query is there any way to do something like ...
Hint the query and generate the query plan then  somehow force the database to 
use this plan when the other non hinted query is run?
Is there anyway do insert a query plan based on a hash id of another query?

Or any other way possible to force a similar result?

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: is it possible to manufacture a query plan.
From: Niall Litchfield

Re: is it possible to manufacture a query plan.
From: joshuasingham

RE: is it possible to manufacture a query plan.
From: Holvoet, Jo

is it possible to manufacture a query plan.

Other related posts: