=?iso-8859-1?q?Gary=20Cowell?= <gary_cowell@yahoo.co.uk> writes:
So it seems the idea that oracle is dropping duplicate
rows prior to the sort when using distinct may indeed
be the case.
So it seems the idea that oracle is dropping duplicate
rows prior to the sort when using distinct may indeed
be the case.
but if you are on PG 7.4 you could get the same effect from using
GROUP BY: instead of
select distinct version from vers where version is not null
try
select version from vers where version is not null group by version
You should get a HashAggregate plan out of that, and I'd think it'd be
pretty quick when there are not many distinct values of version.
regards, tom lane