Processing of queries is additionally optimized by using a built-in statement cache.

A statement cache is an internal memory structure for storing a small number of previously prepared SQL statements. The statement cache operates in such a way that the prepare phase is omitted if the prepared statement is in the cache. If a connection is closed, the statement cache is purged.

In ODBC, the number of cached statements for a session can be set by using the client-side configuration parameter Client.StatementCache, see Client section.

In JDBC, the statement cache size can be dynamically set by using a non-standard StatementCache connection property, see Statement cache property.