Re: Performance question (stripped down the problem) - Mailing list pgsql-general

From Matt Block
Subject Re: Performance question (stripped down the problem)
Date
Msg-id 001601c1404e$5ff1e680$6400000a@internal.home.blockdev.net
Whole thread Raw
In response to Performance question (stripped down the problem)  ("Tille, Andreas" <TilleA@rki.de>)
Responses Re: Performance question (stripped down the problem)
Re: Performance question (stripped down the problem)
List pgsql-general
> -----Original Message-----
> From: Tille, Andreas

> echo "SELECT Hauptdaten_Fall.MeldeKategorie, Count
> (Hauptdaten_Fall.ID) AS Anz FROM Hauptdaten_Fall
> WHERE (((Hauptdaten_Fall.IstAktuell)=20)) GROUP
> BY Hauptdaten_Fall.MeldeKategorie ORDER BY
> Hauptdaten_Fall.MeldeKategorie;" | psql ifsgtest > result

I've not yet looked at the rest of the problem, but doesn't
ORDER BY make GROUP BY redundant?  Just an extra sort?

  -- Matt


pgsql-general by date:

Previous
From: "Kristopher Yates"
Date:
Subject: www.postgresql.org
Next
From: David Emery
Date:
Subject: Re: Second byte of multibyte characters causing trouble