Archives of the TeradataForum
Message Posted: Wed, 26 Jan 2005 @ 22:41:57 GMT
| Subj: || || Re: Record count stored in Data Dictionary |
| From: || || Christie, Jon |
The row count for a table is not stored in the Data Dictionary. A row count for a table is stored in the statistic for the table (if
collected), but there is no reasonable way to get to it with SQL. Also, the count should only be regarded as approximately accurate, since rows
may be inserted on deleted immediately after the statistics were collected.