Background documentationShared SQL Locate this document in the navigation structure

 

The database system can use the shared SQL function to avoid multiple parsing of SQL statements 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 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 or deactivate shared SQL using the UseSharedSQL special database parameter.

More Information

Database Administration, Special Database Parameters