#DateForumTypeThreadPost
426 Oct 2015 @ 09:05 PDTGeneralReplyIs this explain plan normal?So I checked and the view did contcain union between 3 tables there were no conditions inside the view but in the whole query we have additional condition on the view, its something along the lines...
324 Oct 2015 @ 02:29 PDTGeneralReplyIs this explain plan normal?Hi Dieter,  Thanks for the quick replies, its becoming a lot more clear to me now. I shall have to get back to you on this, as all the union part is probably happening in a view used in the q...
224 Oct 2015 @ 11:47 PDTGeneralReplyIs this explain plan normal?Hi Dieter,   Thanks for the answer. I still have some doubts about how optimizer is dealing with this and its estimates/actual rows. If its a union (and it probably is) shouldnt that actual ...
124 Oct 2015 @ 02:50 PDTGeneralTopicIs this explain plan normal?I am noticing some strange behavior in the viewpoint explain. Data is being inserted in the same spool number multiple times. Taking the example of the few steps of an explain given below, we can s...