PFC <[EMAIL PROTECTED]> writes:
> Here you don't need to LEFT JOIN, you can use a straight simple
> unconstrained join because the rows generated by the LEFT JOINs which have
> NULL in the right columns will be rejected by the WHERE clause anyway :
In recent versions of Postgres, the pla
I'd suggest modifying your query generator to make it smarter :
FROM
pubblicita
LEFT OUTER JOIN materiali ON
(pubblicita.codice_materiale=materiali.codice_materiale)
LEFT OUTER JOIN inserzionisti ON
(pubblicita.codice_inserzionista=inserzionisti.codice_inserzionista)
(snip)
WHERE
- Original Message -
From: "_moray" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, March 29, 2005 12:25 PM
Subject: [SQL] a very big table
hullo all,
I have a problem with a table containing a lot of data.
referred tables "inserzionista" and "pubblicazioni&q
hullo all,
I have a problem with a table containing a lot of data.
referred tables "inserzionista" and "pubblicazioni" (referenced 2 times)
have resp. 1909 tuples and 8300 tuples, while this one 54942.
now the problem is that it is slow, also a simple "select * from
pubblicita". (it takes 5-6 se
