RE: OPTIMIZER_SECURE_VIEW_MERGING
"Christian Antognini" <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before posting