Re: Index Scanning

[Richard Huxton <dev@xxxxxxxxxxxx>]

Enrico wrote:
> Hi, I have this query
>
> select TB.id_int,TR.codice_art,importo,cod_iva,prezzo,qta as qta 
> from bolle_carico_testata TB inner join tmp_righe_bolle_carico TR on (TB.id_bolla_rem=TR.id_bolla_rem); 
[snip plan]
> Can anybody tell me why I have two Seq scans instead of two Ind. scan?
> And how can I do to have two ind. scan?

You're fetching all the rows from both tables - what would an index scan 
gain you?

--
  Richard Huxton
  Archonet Ltd