SQL statement cache

The SQL statement cache reduces memory usage and preparation time for queries.

The database server uses the SQL statement cache to store optimized SQL statements that a user runs. When users run a statement that is stored in the SQL statement cache, the database server does not optimize the statement again, so performance improves.

For more information, see Set SQL statement cache parameters. For details on how these parameters affect the performance of the SQL statement cache, see the HCL Informix® Performance Guide.


Copyright© 2019 HCL Technologies Limited