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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
