Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.orgReceived on Thu Jun 14 2007 - 15:20:46 CDT