NULL  and no snapshot exists, a new snapshot is created. The in_views  parameter and the statement_performance_analyzer.limit  configuration option affect the operation of this procedure. 

• delta : Generate a delta analysis. The delta is calculated between the reference table specified by in_table  and the snapshot, which must exist. This action uses the sys schema tmp_digests_delta  temporary table. The in_views  parameter and the statement_performance_analyzer.limit  configuration option affect the operation of this procedure. 

• create_table : Create a regular table suitable for storing the snapshot for later use (for example, for calculating deltas). 

• create_tmp : Create a temporary table suitable for storing the snapshot for later use (for example, for calculating deltas). 

• save : Save the snapshot in the table specified by in_table . The table must exist and have the correct structure. If no snapshot exists, a new snapshot is created. 

• cleanup : Remove the temporary tables used for the snapshot and delta. 

• in_table VARCHAR(129) : The table parameter used for some of the actions specified by the in_action  parameter. Use the format db_name.tbl_name  or tbl_name  without using any backtick ( ‘ ) identifier-quoting characters. Periods ( . ) are not supported in database and table names. 

The meaning of the in_table  value for each in_action  value is detailed in the individual in_action value descriptions. 

• in_views SET (’with_runtimes_in_95th_percentile’, ’analysis’, ’with_errors_or_warnings’, ’with_full_table_scans’, ’with_sorting’, ’with_temp_tables’, ’custom’) : Which views to include. This parameter is a SET  value, so it can contain multiple view names, separated by commas. The default is to include all views except custom . The following values are permitted: 

• with_runtimes_in_95th_percentile : Use the statements_with_runtimes_in_95th_percentile  view. 

• analysis : Use the statement_analysis  view. 

• with_errors_or_warnings : Use the statements_with_errors_or_warnings  view. 

• with_full_table_scans : Use the statements_with_full_table_scans  view. 

• with_sorting : Use the statements_with_sorting  view. 

• with_temp_tables : Use the statements_with_temp_tables  view. 

• custom : Use a custom view. This view must be specified using the statement_performance_analyzer.view  configuration option to name a query or an existing view. 

## Configuration Options 

statement_performance_analyzer()  operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 28.4.2.1, “The sys_config Table” ): 

• debug , @sys.debug 

