The count column is always 0 for Base Tables in SYSTAB system view.
– In the SYSTAB system view, the ‘count’ column only has a row count for system tables.
According to IQ manual, count column means the number of rows in the table or materialized view.
The number of rows in the table or materialized view. This value is updated during each successful checkpoint.
This number is used to optimize database access. The count is always 0 for a non-materialized view or remote table.
2. Test with ASA and Base Table in IQ.
Here are steps to test.
1) ASA Table Test in IQ
1-1) create table test_asa (c1 int) in system; //ASA Area
1-2) insert test_asa values(1);
1-4) select table_name, count from systab where table_name = ‘test_asa’;
2) BASE Table Test in IQ
2-1) create table test_base (c1 int);
2-2) insert test_base values(1);
2-4) select table_name, count from systab where table_name = ‘test_base’;
– The table here in the count column doesn’t mean the base table.
It means that the tables are located in ASA Area.
The column “count” is an attribute of a SQL Anywhere object.
** The only way to get IQ table rowcount is using “select count(*)” in IQ.