Re: Performance question (stripped down the problem)

From: "Matt Block" <matt(at)blockdev(dot)net>
To: "'Tille, Andreas'" <TilleA(at)rki(dot)de>
Cc: "'PostgreSQL General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance question (stripped down the problem)
Date: 2001-09-18 14:29:50
Message-ID: 001601c1404e$5ff1e680$6400000a@internal.home.blockdev.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2001-09-18 15:16:17 Re: locale and spanish acute
Previous Message Gunnar Rønning 2001-09-18 13:24:53 Re: Major change to CVS effective immediately ...