Στις Friday 14 January 2011 16:41:18 γράψατε:
> Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
>
> > and NOT EXISTS
> > (SELECT distinct mold.id from marinerstates
>
> Does that do better if you leave out the DISTINCT keyword? Maybe
> use * instead of the column name?
Its already really fast, it doesn't matter. Anyways just tried without the distinct
...NOT EXISTS (SELECT 1 from ...
and its the same (high) speed. The other form (NOT IN) is the problem (in the case of postgresql-9.0.2).
(in 8.3 both queries are fast)
>
> -Kevin
>
--
Achilleas Mantzios