Re: [PERFORM] repeated subplan execution

2017-09-21 Thread monika yadav
Hi Jeff, Thanks for the update and clarification. I will look to see a better alternative to resolve this twice execution of same plan. On Wed, Sep 20, 2017 at 10:16 PM, Jeff Janes wrote: > On Tue, Sep 19, 2017 at 7:31 PM, monika yadav > wrote: > >> Hi All, >> >> I

Re: [PERFORM] repeated subplan execution

2017-09-19 Thread monika yadav
Hi All, I didn't understand why same sub plan for the sub query executed two times? As per the query it should have been executed only once. Can someone please explain this behaviour of query execution ? Thanks a lot. On Wed, 20 Sep 2017 at 5:01 AM, Jeff Janes wrote: > I have a complicated qu