Re: 2 Informix SE problems

Sally Woolrich <sally@excelsis.co.uk> wrote: :In article <32ACAC1D.3A99@netins.net>, Randy Klindt <kpc@netins.net> :writes :>I have a few Informix SE 5.05 problems.: :> :>1. I have a customer with a database that has around 6 million records :>with about a 300 byte record size. SELECT count(*) FROM <tablename> :>with no where clause takes 5-10 minutes. Same with a dbschema on the :>same table. It seems that the engine is processing every row in the :>table. Shouldn't it get the number out of systables? :It will always count the rows by accessing them all physically. In that case it reads them awfully fast. On a customers SE engine (5.01.UD2) it uses about 1/10 second to count to 12914. This speed has allways been true for all my counts with no where clause on SE and OnLine, whatever the number of rows. I allways believed Informix stored this count somwhere with the table (in the index file?) with SE. It shure isn't in systables as this is only updated when update stistics is run. ...snipp... Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org