I've heard rumors that there is a way to quickly get the (approximate?) number of rows in a table. Robert suggested the query
select num_rows from all_tables where table_name='SE_OBJECT'
However, this query only works for a handful of tables in DESSCI (more in DESOPER). The problem is that NUM_ROWS is not filled automatically. Is there any way to get NUM_ROWS filled for more tables?
Chris Pond has updated the DES_ADMIN tables in DESSCI to have num_rows filled. It is resource-prohibitive to do this in general for all user tables.
DESDB ~> select table_name,owner,num_rows from all_tables where owner='DES_ADMIN' order by table_name;
145 rows in 2.93 seconds
TABLE_NAME OWNER NUM_ROWS
1 COMMENTS_CACHE DES_ADMIN 303
2 COMMENTS_CACHE_BIG DES_ADMIN 660
3 DATABASE_CONFIG DES_ADMIN 5
4 DC4_TRUTH DES_ADMIN 27651054
5 DC6SIM_200SQD_USNOB DES_ADMIN 1092749
6 DC6SIM_USNOB DES_ADMIN 300839
7 DC6_200SQD_TRUTH DES_ADMIN 17749832
Powered by a free Atlassian Confluence Open Source Project License granted to NCSA OpenSource. Evaluate Confluence today.