STMT_CACHE_HITS

onconfig.std value

None (this parameter is not in onconfig.std)

if not present

0

units

Integer

range of values

Any value greater than or equal to 0

takes effect

When the database server is shut down and restarted

utilities

onmode -W STMT_CACHE_HITS
onstat (See The onstat -g ssc Option.)

refer to

The following material:

• Change Settings for the SQL Statement Cache
• Improving query performance, in the IBM Informix Performance Guide

STMT_CACHE_HITS specifies the number of hits (references) to a statement before it is fully inserted in the SQL statement cache. The following table describes the possible values.

Value

Meaning

0

Fully insert all qualified statements in the SQL statement cache.

>0

The first time a user issues a unique statement, the database server inserts a key-only entry in the cache that identifies the statement. Subsequent identical statements increment the hit count of the key-only cache entry. When the hit count of the key-only cache entry reaches the specified number of hits, the database server fully inserts the statement in the cache. Set hits to 1 or more to exclude ad hoc queries from entering the cache.