SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS system procedure
invalidates all system prepared statements, and forces the query
optimizer to create new execution plans. You can use this to speed up
query execution by the data dictionary when performance has become
If you notice that
ij show commands have slowed down, you can call
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS to refresh the execution
Splice Machine uses prepared statements known as system procedures to access data in the system tables. These procedures are cached, along with their execution plans, in the data dictionary. The cached execution plans can become sub-optimal after you issue a large number of schema-modifying DLL statements, such as defining and/or modifying a number of tables.
This procedure does not return a result.
splice> CALL SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS(); Statement executed.