Archives of the TeradataForum
Message Posted: Fri, 28 Jan 2005 @ 21:20:09 GMT
| Subj: || || Re: Record count stored in Data Dictionary |
| From: || || Victor Sokovin |
| ||Oracle provides the record count for any user table, wanted to find out if we have some thing similar in Teradata.|| |
Last time I checked Oracle was providing row counts only for tables for which statistics had been collected. I can't recall now whether
ANALYZE TABLE. ESTIMATE STATISTICS was enough for reliable counts. I think only COMPUTE STATISTICS could provide them, which means a full table
scan still must be done.