Isak,
Looks to me like most of the time is spent doing "not in (select a ton
of rows from bilkaib)".
Try something like "not exists (select null from bilkaib b where
b.dokumnr = dok.dokumnr and alusdok = 'LY')".
Thank you very much.
Query seems to return now immediately.
dok.dokumnr is not null
bilkaib.dokumnr can be null
I hope that modified query produces same results as original.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
