This chapter describes the statement cache, which is used for saving SQL of cached statements. Adaptive Server compares incoming SQL to its cached SQL, and if they are equal, it executes the plan of the SQL already saved. This allows the application to amortize the costs of query compilation across several executions of the same statement.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
