The statement cache adds the set statement cache parameter.
This is the partial syntax for set:
set statement_cache [on | off]
statement_cache – enables or disables the statement cache at the session level. Once a use with SA priviledges configures the statement cache size to a non-0 value, the session can enable and disable the statement cache at the session level. If the statement cache is configured at the server level, by default it is enabled at the session level.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
