Re: is it possible to manufacture a query plan.

From: Ian Cary <Ian.Cary_at_ons.gsi.gov.uk>
Date: Thu, 23 Feb 2012 15:51:33 +0000
Message-ID: <OF2369BEF7.5253C969-ON802579AD.0056F579-802579AD.0057233C_at_ons.gsi.gov.uk>

There is a package sys.dbms_advanced_rewrite which has a few limitations but may be able to do what you want i.e. add a hint

Cheers,

Ian

|---------+----------------------------->


|         |           DHayden_at_sprich.com|

|         |           Sent by:          |

|         |           oracle-l-bounce_at_fr|

|         |           eelists.org       |

|         |                             |

|         |                             |

|         |           23/02/2012 15:25  |

|         |           Please respond to |

|         |           DHayden           |

|         |                             |

|---------+----------------------------->
  >--------------------------------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                                                  |
  |       To:       oracle-l_at_freelists.org                                                                                                           |
  |       cc:                                                                                                                                        |
  |       Subject:  is it possible to manufacture a query plan.                                                                                      |
  |                                                                                                                                                  |
  |                                                                                                                                                  |
  >--------------------------------------------------------------------------------------------------------------------------------------------------|

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






For the latest data on the economy and society consult National Statistics at http://www.ons.gov.uk

*********************************************************************************


Please Note:  Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
*********************************************************************************


Legal Disclaimer  :  Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
*********************************************************************************


The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless Worldwide in partnership with MessageLabs. (CCTM Certificate Number 2009/09/0052.) On leaving the GSi this email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
--
http://www.freelists.org/webpage/oracle-l

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