Subject: OPTIMIZER_SECURE_VIEW_MERGING 2007-08-30 - By Martin Klier
Back
Hi DBA's,
does somebody know what 10gR2 init parameter "OPTIMIZER_SECURE_VIEW_MERGING"
does in detail? Oracle Documentation says "allows you to enable or disable
view merging globally for the database" what I do not consider as very
informative. :)
I am concerned about this sentence: "To take advantage of query rewrite for a
particular query, you must disable the OPTIMIZER_SECURE_VIEW_MERGING
parameter."
Does that mean I have to set OPTIMIZER_SECURE_VIEW_MERGING=false to use query
rewriting at all?
Thanks in advance and best regards
--
Freundliche Gr??e
i.A.
Martin Klier
Systemadministration/Datenbanken
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
A.T.U Auto-Teile-Unger
Handels GmbH & Co. KG
Dr.-Kilian-Str. 4
92637 Weiden i.d. OPf.
Tel.: +49 961 306-5663
Fax : +49 961 306-5982
martin.klier@(protected)
www.atu.eu
Sitz: Weiden i. d. Opf., Amtsgericht Weiden i. d. OPf., HRA 2012
UST-ID Nr. DE814195392, WEEE-Nr. DE53789710
Pers?nlich haftende Gesellschafterin:
AFM Autofahrerfachmarkt Gesch?ftsf?hrungs GmbH
Sitz: Weiden i. d. OPf., Amtsgericht Weiden i. d. OPf., HRB 2842
Gesch?ftsf?hrer: Karsten Engel, Dirk M?ller, Manfred Ries
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
|
|
