Number of rows i systables

Posted in 2000

Summary

Nils Larsson found systables.numrow differed from actual row counts and asked for an alternative to count(*). Yuri Dovgart suggested systabinfo.ti_nrows and noted UPDATE STATISTICS refreshes systables; Jiri Lisicky also advised update statistics. Art Kagel said sysmaster:sysptnhdr, keyed by partnum, always has an accurate row count.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Server Administration

Nils Larsson — Tue, 18 Apr 2000 08:17:25 +0200 — source: Informix-list mailing list archive (1991-1998)

We have developed an alternativ to DBaccess and during testing we discovered that the information in systables.numrow differs from the actual number of rows for some of our tables - not all tables. Is there another way of obtaining the number of rows in a table except count (*) ? TIA Jan Nilsson pro IT jan@proitkarlstad.se

↪ replying to Nils Larsson

Yuri Dovgart — Tue, 18 Apr 2000 11:55:38 +0400 — source: Informix-list mailing list archive (1991-1998)

Nils Larsson <nla@tek.pliktverket.se> wrote in message news:8dguqt$osp1@www.informix.com... > We have developed an alternativ to DBaccess and during testing we discovered > that the information in systables.numrow differs from the actual number of > rows for some of our tables - not all tables. > Is there another way of obtaining the number of rows in a table except count > (*) ? You can look into the systabinfo table, field ti_nrows. Information in systables will be updated with UPDATE STATISTICS. -- ------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Informix Certified Professional, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > TIA > > Jan Nilsson > pro IT > > jan@proitkarlstad.se > > >

↪ replying to Nils Larsson

Jiri Lisicky — Tue, 18 Apr 2000 09:08:22 GMT — source: Informix-list mailing list archive (1991-1998)

On Tue, 18 Apr 2000 08:17:25 +0200, "Nils Larsson" <nla@tek.pliktverket.se> wrote: >We have developed an alternativ to DBaccess and during testing we discovered >that the information in systables.numrow differs from the actual number of >rows for some of our tables - not all tables. >Is there another way of obtaining the number of rows in a table except count >(*) ? update statistics and then select again. -- Jiří Lisický ČD DATIS Olomouce-mail: lisicky@datis.cdrail.cz Nerudova 1 phone: +420-068-472-5496 Olomouc, Czech Republic >>> čeština ISO-8859-2 Compatible <<<

↪ replying to Nils Larsson

Art S. Kagel — Tue, 18 Apr 2000 10:23:20 -0400 — source: Informix-list mailing list archive (1991-1998)

Nils Larsson wrote: > We have developed an alternativ to DBaccess and during testing we discovered > that the information in systables.numrow differs from the actual number of > rows for some of our tables - not all tables. > Is there another way of obtaining the number of rows in a table except count > (*) ? In the sysmaster SMI database the sysptnhdr table is a window into the table's header information on disk. The row count there is accurate all the time. It is keyed by partnum to the sysmaster:systabnames table or the corresponding systables or sysfragments record in the database catalog. Art S. Kagel

Related threads

Glossary

dbaccess