Marco Aurélio V. da Silva <marcoprodata@xxxxxxxxx> writes: > Select a.CodPagador,b.Descricao > From Frete01 a Left Outer Join Frete02 b On (a.CodPagador = b.CodCliente) > > explain in good dabatase: > "Limit (cost=0.00..46856.62 rows=55204 width=39) (actual > time=11.205..536.761 rows=55204 loops=1)" That doesn't match the query you describe. Notably there's no LIMIT in the query (or the other plan) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
