Subject: RE: OPTIMIZER_SECURE_VIEW_MERGING 2007-08-30 - By Christian Antognini
Back
Hi Martin
> does somebody know what 10gR2 init parameter
OPTIMIZER_SECURE_VIEW_MERGING
> does in detail?
With the initialization parameter OPTIMIZER_SECURE_VIEW_MERGING set to
TRUE the query optimizer checks if view merging could lead to security
issues. If it is the case no view merging is performed and, therefore,
performance could be sub-optimal.
> Does that mean I have to set OPTIMIZER_SECURE_VIEW_MERGING?lse to
use
> query rewriting at all?
No. There are cases where the query optimizer does the merge even if
it's set to TRUE. The question is: Are you using views for security
purposes? If the answer is no, set it to FALSE. Otherwise, use the
default value (TRUE).
HTH
Chris
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
