Stop restarting of inner plan??

Started by Ramanujam H S Iyengarover 21 years ago2 messages
#1Ramanujam H S Iyengar
hals_ramu@hotmail.com

Hello,

Can someone tell me how can i let the inner plan in a nestloop join NOT to
restart for each tuple of the outer Plan ..
so essentially, my inner plan has to be executed only once and not 'n' times
.. where 'n' is the number of outer tuples ...

I tried by commenting ExecReScan(innerPlan, econtext, (Plan *) node); at
line # 154 in nodeNestLoop.c .. but that is not working out !! :-\

Some one can please educate me about what is happenning !!!

-Ramu

_________________________________________________________________
Contact brides & grooms FREE! http://www.shaadi.com/ptnr.php?ptnr=hmltag
Only on www.shaadi.com. Register now!

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ramanujam H S Iyengar (#1)
Re: Stop restarting of inner plan??

"Ramanujam H S Iyengar" <hals_ramu@hotmail.com> writes:

Can someone tell me how can i let the inner plan in a nestloop join NOT to
restart for each tuple of the outer Plan ..

You can't. At least, not if you want the correct results from the join.

regards, tom lane