Performance -> SQL Patch

Note

You can create new SQL Patch in SQL Details view.

This page lists all SQL Patches.

Columns of the table are as follows:

• SQL ID - SQL ID of the statement for which the patch was created. If patch was created manually (without APPM), then this column displays SQL signature number. Editing of such manually created patch is not possible.
• Name - User defined (or auto generated) name of SQL Patch. This is unique among all SQL patches.
• Hint - Hints that are applied using this patch. Those written in blue color are valid hint names and those in red color have syntax error.
• Status - Tells if this patch is enabled or disabled. Only one SQL Patch may be enabled at a time. (Note to advanced user: only one patch per group may be active, but APPM only operates in DEFAULT group).
• F. Match - If force matching is used.
• Created - Date when the patch was created.
• Last Modified - Date when the patch was last modified.
• Opts - You may enable/disable or delete or edit any patch listed.