sys Schema Stored Procedures 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 5198