RE: is it possible to manufacture a query plan.
Date: Thu, 23 Feb 2012 15:57:53 +0000
Message-ID: <ED8913458C966249856499C923CE5C8B18D0D83F_at_prd-dag-01.ad.sprich.com>
11.2.0.2
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Thursday, February 23, 2012 10:33 AM To: Dustin Hayden
Cc: oracle-l_at_freelists.org
Subject: Re: is it possible to manufacture a query plan.
Which Oracle version and edition?
On Thu, Feb 23, 2012 at 3:25 PM, Dustin Hayden <DHayden_at_sprich.com<mailto: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:57:53 CST