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
