Hello,
Today, we stumbled about the following query plan on PostGreSQL 7.4.1:
logigis=# explain select count(id) from (select distinct id from (select distinct
ref_in_id as id from streets union select distinct nref_in_id as id from streets) as
blubb) as blabb;
Markus Schaber [EMAIL PROTECTED] writes:
Today, we stumbled about the following query plan on PostGreSQL 7.4.1:
logigis=# explain select count(id) from (select distinct id from (select distinct
ref_in_id as id from streets union select distinct nref_in_id as id from streets) as
blubb) as
Markus Schaber [EMAIL PROTECTED] writes:
logigis=# explain select count(id) from (select ref_in_id as id from streets union
select nref_in_id as id from streets) as blubb;
QUERY PLAN