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

On Tue, 18 Sep 2001, Matt Block wrote:

> > 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?
No it doesn´t.  I have to do exact this query.

Kind regards

         Andreas.