The statement cache is used for saving SQL from cached statements. Adaptive Server 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.
