Dennis Björklund wrote:
On Fri, 9 Jan 2004, Richard Huxton wrote:
select invheadref, invprodref, sum(units)
from invtran
group by invheadref, invprodref
For the above query, shouldn't you have one index for both columns
(invheadref, invprodref). Then it should not need to sort at all
Hi,
We've set up a little test box (1GHz Athlon, 40G IDE drive, 256M RAM,
Redhat 9) to do some basic comparisons between postgresql and firebird
1.0.3 and 1.5rc8. Mostly the results are comparable, with one
significant exception.
QUERY
select invheadref, invprodref, sum(units)
from invtran
gro
