derby.storage.indexStats.log The derby.storage.indexStats.log property, if set to true, specifies that the thread that updates index cardinality statistics during query compilation will write messages to the system log (derby.log) every time it performs a task. derby.storage.indexStats.log property databaseslogging automatic updating of statistics statisticslogging automatic updating index statisticslogging automatic updating

The log entries should help you to diagnose problems with the automatic updating of index statistics.

The property can be used to provide more detailed information and to specify where the trace output should appear.

To disable the automatic updating of index statistics, set the database property to false.

For more information about index statistics, see "Working with cardinality statistics" in .

Default

False.

Example -- system-wide property derby.storage.indexStats.log=true -- database-level property CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 'derby.storage.indexStats.log', 'true')
Dynamic or static

Static. For system-wide properties, you must reboot for the change to take effect. For database-wide properties, you must reboot the database for the change to take effect.