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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: optimizer_secure_view_merging

RE: optimizer_secure_view_merging

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 19 Dec 2006 18:08:51 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF8B57B3@MSXVS04.trivadis.com>


Todd

> If optimizer_secure_view_merging will only help on the parse, then I
am
> barking up the wrong tree and will need to find a better solution.

optimizer_secure_view_merging should only avoid view merging in some specific cases where security is involved. Therefore the only impact on the execution I can imagine is related to different execution plans (because of the lack of view merging).

Cheers,
Chris

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 19 2006 - 11:08:51 CST

Original text of this message

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