xxxx=# explain select * from sites s join site_screens ss on s.oid =
ss.id_site; QUERY PLAN
---------------------------------------------------------------------------
Hash Join (cost=...)
Hash Cond: ("outer".id_site = "inner".oid)
-> Seq Scan on site_screens ss (cost=...)
-> Hash (cost=...)
-> Seq Scan on sites s (cost=...)
You've commented out the interesting bits (the costs/rows)
I want to Index Scan. What must I do?
Why do you want an index scan? Do you have any evidence it will be faster than a sequential scan?
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
