Get Real Row Counts in GBase 8s Without UPDATE STATISTICS

The nrows column in systables is only updated when you run UPDATE STATISTICS , so it often shows 0 even right after bulk inserts. If you need the real, live row count — especially for fragmented tables — you can query sysmaster:sysptnhdr or use oncheck . Non‑Fragmented Tables Join systables.partnum with sysptnhdr.partnum in the sysmaster database. sysptnhdr.nrows gives the actual row count and npdata the number of used data pages. SELECT t . tabname , t . partnum , t . nrows , p . nrows , p . np