Re: QUES: How to get count using OnLine ESQL/C

Posted in 1995

"Andy Kent" — Wed, 5 Apr 1995 08:30:22 GMT — source: Informix-list mailing list archive (1991-1998)

> You can use either select count(*) or access the systables and get the # of > rows for te table in which you are interested. ... as long as you've run UPDATE STATISTICS on that table since any rows were inserted or deleted. Well, for most purposes, as long as you did that since any *significant* number of rows were inserted or deleted. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England