zigzagdna_at_yahoo.com wrote:
> 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.
In what version? Test it!
--
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
Received on Thu Jun 14 2007 - 17:14:46 CDT
