The Statement Cache

The statement cache saves SQL from cached statements.

SAP ASE compares incoming SQL statements to its cached SQL statements, and if they are equal, it executes the plan of the SQL statements already saved. This allows the application to amortize the costs of query compilation across several executions of the same statement.

• Setting the Statement Cache
  The statement cache lets SAP ASE compare a newly received ad hoc SQL statement to cached SQL statements. If a match is found, SAP ASE uses the plan cached from the initial execution.