Re: Performance question

On Mon, 10 Sep 2001, Einar Karttunen wrote:

> ...
> temp=# CREATE INDEX hfia ON Hauptdaten_Fall (IstAktuell);
> CREATE
> temp=# explain SELECT MeldeKategorie,count(ID) FROM Hauptdaten_Fall
> temp-# WHERE IstAktuell=20 GROUP BY MeldeKategorie
> temp-# ORDER BY MeldeKategorie;
> NOTICE: QUERY PLAN:
>
> Aggregate (cost=8.30..8.35 rows=1 width=16)
> -> Group (cost=8.30..8.33 rows=10 width=16)
> -> Sort (cost=8.30..8.30 rows=10 width=16)
> -> Index Scan using hfia on hauptdaten_fall (cost=0.00..8.14 rows=10 width=16)
>
Thanks for the hint but the index exists but is not used (see my previous
mail with a detailed description).

Kind regards

Andreas.