Statement and Stored Procedure System Procedures and Functions

These are the system procedures and functions for working with executing statements and stored procedures:

Procedure / Function Name Description
SYSCS_UTIL.SYSCS_EMPTY_GLOBAL_STATEMENT_CACHE Removes as many compiled statements (plans) as possible from the database-wide statement cache (across all region servers).
SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE Removes as many compiled statements (plans) as possible from the database statement cache on your current region server.
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS Invalidates all system prepared statements and forces the query optimizer to create new execution plans.
SYSCS_UTIL.SYSCS_UPDATE_ALL_SYSTEM_PROCEDURES Updates the signatures of all of the system procedures in a database.
SYSCS_UTIL.SYSCS_UPDATE_SYSTEM_PROCEDURE Updates the stored declaration of a specific system procedure in the data dictionary.