[HACKERS] Doubt in index subplan query

2008-06-20 Thread Suresh
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) Index

Re: [HACKERS] Doubt in index subplan query

2008-06-20 Thread Decibel!
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