<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;" valign="top">Hello,<br /><br />I have
aquery plan for a certain query<br /><br /> Nested Loop (cost=100000000.00..38761761090.50 rows=3000608 width=8)<br
/> -> Seq Scan on lineitem (cost=100000000.00..100213649.15 rows=6001215 width=8)<br /> -> Index Scan using
oindex2on myorders (cost=0.00..6442.27 rows=1 width=4)<br /> Index Cond: ("outer".l_orderkey =
myorders.o_orderkey)<br/> Filter: (subplan)<br /> SubPlan<br /> -> Index Scan using
cnationon customer (cost=0.00..12859.39 rows=5251 width=0)<br /> Index Cond: (c_nationkey = 10)<br
/><br/>How is the subplan handled by postgres at index level ? Is any sort of hashing done ?<br /><br />Thanks and
regards,<br/>Suresh<br /><br /></td></tr></table><br />