Can SQL statements force when is NUM_ROWS populated in the USER_TABLES?

I'm just wondering if there is a situation where Oracle will update the NUM_ROWS(and possibly other statistics) through usual database use.

I know this can be forced using Analyze and other DBMS procedures and other background processes, but I'm not interested in that (at this point).

I have experimented with some methods unsuccessfully such as
Using different sizes of tables, and simple select statements
nebblesAsked:
Who is Participating?
 
sdstuberConnect With a Mentor Commented:
Oracle will not update num_rows except through analyze or dbms_stats commands.

In 10g there is a dbms_scheduler job to automatically collect statistics.
So, dbms_stats maybe still be used even if you are not doing it yourself.
0
All Courses

From novice to tech pro — start learning today.