Re: count(*)

Posted in 1999

Obnoxio The Clown — Fri, 23 Apr 1999 06:37:47 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Gaetano Mendola" <mendola@bigfoot.com> >Is more fast count(*) or count(table.column) ? I tried this on a table with 1000000 records and table.column was UPDATEd STATISTICS HIGH and indexed. COUNT(*) took 0.11 seconds, COUNT(table.column) took 18.45 seconds. >I have Informix SE-ONLINE 7.23. Which one? SE or OnLine? I tried this with OnLine 7.24... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com