Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE

csn <csn233_at_gmail.com> wrote:

>
>> After some investigation I found that just setting the following
>> parameter resulted in a huge (about 100-fold) performance increase:
>> OPTIMIZER_SECURE_VIEW_MERGING=FALSE
>
>If I can improve performance 100-fold, I wouldn't worry about other
>things too much but go to the manager and ask for a pay raise instead.

Yes but wait... Performance was already acceptable prior to the Upgrade. I did not really improve things, just fixed a problem.

If my salary would depend on improvements of this kind, I would get rich for sure. There is still room for improvement, absolutely!

Bye

Rick Denoire Received on Sun Dec 02 2007 - 13:28:23 CST