•
|
If you set both SET statements to zero, the database engine does not cache stored procedures. In addition, the engine removes any existing cache used for stored procedures. That is, the engine flushes from cache all stored procedures that were cached before you set both statements to zero.
|
•
|
If you set only one of the statements to a value, either zero or a nonzero value, the other statement is implicitly set to zero. The statement implicitly set to zero is ignored. For example, if you are only interested in caching 70 procedures and are not concerned with the amount of memory, set CACHED_PROCEDURES to 70. The database engine implicitly sets PROCEDURES_CACHE to zero, which ignores the setting.
|
2
|
For this key, create a new string valued named CachedProcedures.
|
3
|
Set CachedProcedures to the desired number of procedures that you want to cache.
|
2
|
For this key, create a new string valued named CachedProcedures.
|
3
|
Set CachedProcedures to the desired number of procedures that you want to cache.
|
•
|
•
|
•
|
The stored procedure contains an EXEC[UTE] statement used to execute a character string, or an expression that returns a character string. For example: EXEC ('SELECT Student_ID FROM ' + :myinputvar).
|