<div>
<div class="content wysiwyg-content">
I'm just wondering if there is a situation where Oracle will update the NUM_ROWS(and possibly other statistics) through usual database use.<br />
<br />
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).<br />
<br />
I have experimented with some methods unsuccessfully such as<br />
Using different sizes of tables, and simple select statements <br />

</div>
</div>


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 


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

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.