tag:blogger.com,1999:blog-5124641802818980374.post5339073308910335498..comments2023-09-06T11:58:30.752+02:00Comments on Oracle related stuff: Join Views, ROWIDs And Query TransformationsUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5124641802818980374.post-11711982516837876122012-05-25T15:52:42.295+02:002012-05-25T15:52:42.295+02:00hi Randolf,
thanks for your update on this.
Even ...hi Randolf,<br /><br />thanks for your update on this.<br />Even before I read your update, I modified the code of the view with that NO_MERGE hint ;-)<br /><br />... and fortunatelly it worked well after that change!<br /><br />thanks again for your help and best regards StefanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-49334714929678702782012-05-25T12:20:48.053+02:002012-05-25T12:20:48.053+02:00Hi Stefan,
first of all I think it would require ...Hi Stefan,<br /><br />first of all I think it would require a detailed analysis of the particular case how SQL statement and the execution plan in question looks like.<br /><br />It is probably not a good idea to disable view merging in general, the side effects would potentially be huge.<br /><br />It might be more reasonable to see if a simple NO_MERGE hint for the particular statement failing is sufficient to prevent the problem without suffering too much performance.<br /><br />Potentially a re-write of the statement allows preventing the problem, too.<br /><br />RandolfRandolfhttps://www.blogger.com/profile/13463198440639982695noreply@blogger.comtag:blogger.com,1999:blog-5124641802818980374.post-78970230067899712562012-05-25T08:24:58.521+02:002012-05-25T08:24:58.521+02:00hi Randolf,
the last time you helped me with that ...hi Randolf,<br />the last time you helped me with that topic in the OTN.<br />Unfortunatelly I got the message that this error occured again even with disabling the "outer join elimination" feature. <br />Therefore I googled around and saw that you updated your blog with tests of that issue. <br />Do you have an advice, how to disable both: Simple View Merging, and the Outer Join Elimination?<br />For disabling the second one, I set the _fix_control parameter to "4967068:OFF"... how the best thing to disable the other one or will I have negative side effects when doing this?<br /><br />thanks again in advance for your advises and best regards<br />StefanStefannoreply@blogger.com