There are some reasons which can cause “update statistics” won’t be executed, for example: after migrate DB from 5.1 to 5.3, then execute update statistics and rebuild index, if you execute update statistics again, index statistics information won’t be updated.

We list the factors which will impact "update statistics" behaviors:

-----------------

1. New table and never execute "update statistics

2. The table's record numbers less than 20 pages

3. Added record numbers more than 2 pages

4. Update statistics operations had over 10 days

5. If execute update statistics operations on Table when meet above 1/2/3/4, and statistics info for indexes of this table will be updated.

We support a new SQL syntax to force execute "update statistics" as following.

Version: 5.3.3, 5.4.1

Product: Normal/Bundle

Platform: Windows/Linux