1
0
-1

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?

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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
      ...
        CommentAdd your comment...