Re: [BUGS] Bug in optimizer

[Gaetano Mendola]

Timo Nentwig wrote:

This is very slow:

SELECT urls.id FROM urls WHERE
(
    urls.id <> ALL (SELECT html.urlid FROM html)
);

...while this is quite fast:

SELECT urls.id FROM urls WHERE
(
    NOT (EXISTS (SELECT html.urlid FROM tml WHERE
    (
        html.urlid = urls.id
    )))
);

Are you using the version 7.4.x ?

Regards
Gaetano Mendola

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings