Re: [HACKERS] Doubt in index subplan query

On Jun 20, 2008, at 1:11 AM, Suresh wrote: I have a query plan for a certain query Nested Loop (cost=1.00..38761761090.50 rows=3000608 width=8) -> Seq Scan on lineitem (cost=1.00..100213649.15 rows=6001215 width=8) -> Index Scan using oindex2 on myorders (cost=0.00.

[HACKERS] Doubt in index subplan query

Hello, I have a query plan for a certain query  Nested Loop  (cost=1.00..38761761090.50 rows=3000608 width=8)    ->  Seq Scan on lineitem  (cost=1.00..100213649.15 rows=6001215 width=8)    ->  Index Scan using oindex2 on myorders  (cost=0.00..6442.27 rows=1 width=4) Inde