Re: is it possible to manufacture a query plan.
Date: Thu, 23 Feb 2012 15:33:20 +0000
Which Oracle version and edition?
On Thu, Feb 23, 2012 at 3:25 PM, Dustin Hayden <DHayden_at_sprich.com> wrote:
> 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?
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 23 2012 - 09:33:20 CST