Adaptive Server matches an ad hoc SQL statement to a cached statement by the SQL text and by login (particularly if both users have sa_role), user ID, database ID, and session state settings. The relevant session state consists of settings for the following set command parameters:
forceplan
jtc
parallel_degree
prefetch
quoted_identifier
sort_merge
table count
transaction isolation level
chained (transaction mode)
Settings for these parameters determine the behavior of the plan Adaptive Server produces for a cached statement. For information on the set command and its parameters, see the Adaptive Server Reference Manual.
You must configure set chained on/off in
its own batch if you enable the statement cache.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
