The SQL Performance Analyzer Task: IMMCHAN.SPA_OPTIMIZER_STATS page is shown. The Page Refreshed field shows Jul 26, 2010 5:43:29 PM PDT. The Refresh button is shown.
The SQL Tuning Set section is collapsed.
The SQL Trials section includes the following text: "A SQL Trial captures the execution performance of the SQL Tuning Set under specific environmental conditions."
The table includes the following columns: SQL Trial Name, Description, Created, SQL Executed, and Status.
Row 1 has the following values: INITIAL_SQL_TRIAL, parameter optimizer_use_pending_statistics set to FALSE, 7/26/10 5:37 PM, Yes, COMPLETED.
Row 2 has the following values: SECOND_SQL_TRIAL, parameter optimizer_use_pending_statistics set to TRUE, 7/26/10 5:38 PM, Yes, COMPLETED.
The SQL Trial Comparisons section is shown. The text is: "Compare SQL Trials to assess change impact of environmental differences on SQL Tuning Set execution costs." The Run SQL Trial Comparison button is shown.
The table has the following columns: Trial 1 Name, Trial 2 Name, Compare Metric, Created, Status, Comparison Report, and SQL Tune Report.
Row 1 has the following values: INITIAL_SQL_TRIAL, SECOND_SQL_TRIAL, Optimizer Cost, 7/26/10 5:38 PM, COMPLETED, (sunglasses icon), and null.
End of description.