> What does explain show for the exists version?
suryadb=# explain select * from dbmedia where EXISTS (select ID from wdmedia where word='whatever' AND dbmedia.id=id )
LIMIT200;
NOTICE: QUERY PLAN:
Limit (cost=0.00..1006732.42 rows=200 width=76)
-> Seq Scan on dbmedia (cost=0.00..507810931.25 rows=100883 width=76)
SubPlan
-> Index Scan using wdkmedia on wdmedia (cost=0.00..5033.63 rows=1 width=4)
EXPLAIN
still seq scan :((
someone please fix this bug :(
--
------
Varun
Once I finally figured out all of life's answers.....they changed the questions.