Re: index scan

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