Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query_rewrite_enabled parameter

Re: query_rewrite_enabled parameter

From: <zigzagdna_at_yahoo.com>
Date: Thu, 14 Jun 2007 13:44:07 -0700
Message-ID: <1181853847.685430.46940@z28g2000prd.googlegroups.com>


On Jun 14, 4:20 pm, DA Morgan <damor..._at_psoug.org> wrote:
> zigzag..._at_yahoo.com wrote:
> > I am not using function based indexes or materialized views. If I set
> > this parameter=FALSE, will cost optimzer do something?. What are the
> > advantages of setting this parameter Query_rewtite_enabled=TRUE.
>
> It will definitely do something. Whether that is something you want
> is quite another question.
>
> The solution is to set up a testing environment and use it.
>
> What you have not indicted is why you think this is a good idea.
> What is happening to lead you to that conclusion. Explain Plan
> examples would be helpful.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Oarcel provides a hinted called UNNESTED which will "rerewite" query to merge sub query to driving query. Does this hint reqyure this paremetr to be TRUE. Received on Thu Jun 14 2007 - 15:44:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US