Using the SQL statement cache

The DBA usually makes the decision to enable the SQL statement cache. If the SQL statement cache is enabled, individual users can decide whether or not to use the SQL statement cache for their specific environment or application.

The database server incurs some processing overhead in managing the SQL statement cache, so you should use the SQL statement cache only when multiple users want to share the SQL statements.

To enable the SQL statement cache, set the STMT_CACHE configuration parameter to a value that defines either of the following modes:

• Always use the SQL statement cache unless a user explicitly specifies do not use the cache.
• Use the SQL statement cache only when a user explicitly specifies use it.

For more information, see Enabling the SQL statement cache. For more information about the STMT_CACHE configuration parameter, see the HCL Informix® Administrator's Reference.