Symptom
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.
Column name |
Data type |
Description |
count |
UNSIGNED BIGINT |
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. |
Read more...
Environment
- SAP IQ 16
- SAP IQ 15.x
Product
Keywords
KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.