SYSCS_UTIL.SYSCS_UPDATE_METADATA_STORED_STATEMENTS

The SYSCS_UPDATE_METADATA_STORED_STATEMENTS system procedure updates the execution plan for stored procedures in your database.

About System Procedures and Metadata

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.

You typically need to call this procedure (along with the SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE procedure whenever you update your Splice Machine software installation.

If you have called the SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS system procedure to improve query speed, and performance is still sub-optimal, it is probably because the query optimizer needs some manual hints to generate an optimal execution plan.

The manual hints are stored in the metadata.properties file, which is external to the database. Versions of this file are typically supplied by Splice Machine consultants or engineers.

Use this function to update the execution plans stored in the data dictionary.

Syntax

SYSCS_UPDATE_METADATA_STORED_STATEMENTS()

Results

This procedure does not return a result.

Example

splice> CALL SYSCS_UPDATE_METADATA_STORED_STATEMENTS();
Statement executed.

See Also