RE: count and count distinct

Posted in 2000

Thiel Franky — Thu, 21 Sep 2000 13:27:16 +0200 — source: Informix-list mailing list archive (1991-1998)

Do you run update statistics frequently ? -----Oorspronkelijk bericht----- Van: Anna Zygmunt [mailto:azygmunt@agh.edu.pl] Verzonden: woensdag 20 september 2000 15:22 Aan: informix-list@iiug.org Onderwerp: Re: count and count distinct I've table with about 600 000 records. I see that 'count' and 'count distinct' are running about 4-6 minutes. What should I do (on which column put indexes, or substitute these operations by others) to improve performance? Thanks, Anna Zygmunt