Mihail Nasedkin wrote:
> 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