Re: Performance question (stripped down the problem)

> -----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