Re: is it possible to manufacture a query plan.

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 23 Feb 2012 15:33:20 +0000
Message-ID: <CABe10sZXRDgoY9uqRMJgWGeDUD05_XhxOaqZBQt_OkR-mNLGug_at_mail.gmail.com>

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?
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


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

Received on Thu Feb 23 2012 - 09:33:20 CST