Re: query_rewrite_enabled parameter

zigzagdna_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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org