Date: Thu, 08 Mar 2012 23:08:02 +0200
The estimate would be something like your formula. Check also LAST_ANALYZED and does NUM_ROWS match count(*).
|AVG_ROW_LEN*| |NUMBER| Average length of a row in the table (in bytes)
How full are the used column data types populated? Does_ALL_TAB_COLUMNS
AVG_COL_LEN match DATA_LENGTH
_http://docs.oracle.com/cd/E11882_01/server.112/e25513/statviews_2103.htm#I1020277 Will the future 600k row be poplated with similar data? You will not know. But it is an estimate.
-- Timo Raitalaakso http://rafudb.blogspot.com 8.3.2012 22:43, Zelli, Brian kirjoitti:Received on Thu Mar 08 2012 - 15:08:02 CST
> So I can see that the average row length in my table is 263. Is that bytes? And if I want to estimate another 600,000 rows I multiply the 600,000 by 263?