SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS

The 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 sub-optimal.

If you notice that ij show commands have slowed down, you can call SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS to refresh the execution plans.

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.

Syntax

SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS()

Results

This procedure does not return a result.

Example

splice> CALL SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS();
Statement executed.

See Also