 |
 |
Archives of the TeradataForum
Message Posted: Thu, 27 Jan 2005 @ 14:59:51 GMT
| Subj: | | Re: Record count stored in Data Dictionary |
| |
| From: | | Geoffrey Rommel |
| | I would like to know if the record count for a table is stored in Teradata DD (Data Dictionary) | |
This question comes up a lot. I don't know of any DBMS that keeps track of the number of rows in every table, and yet people keep asking
for it.
If keeping track of the exact number of rows in certain tables is important to you, you could keep the count in a table (defined as, say,
decimal(15) rather than integer) and then update it with triggers: add 1 for each insert, subtract 1 for each delete. It would also be wise to
update the number by actually running "select count(*)" in a weekly batch job, just to make sure. Seems like a lot of overhead, though....
| |
