Shared SQL

The database system can use shared SQL to avoid multiple parsing and multiple storage of parse information (such as execution plans and descriptions of result sets).

If shared SQL is activated, the database system saves all parsed SQL statements and particularly prepared statements with their corresponding information in a global cache, shared by all users. The system can use this information again later, if needed.

You can activate shared SQL with the special database parameter SHARED_SQL.

See also:

Concepts of the Database System, Special Database Parameters