RE: OPTIMIZER_SECURE_VIEW_MERGING

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=false 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-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting