General Information

Task Information:
Workload Information:
Task Name : TASK_364
Task Owner : SYS
Description :
SQL Tuning Set Name : spa_test_sqlset
SQL Tuning Set Owner : SYS
Total SQL Statement Count : 6

Execution Information:
Execution Name : EXEC_350
Execution Type : COMPARE PERFORMANCE
Description :
Scope : COMPREHENSIVE
Status : COMPLETED
Number of Unsupported SQL : 1
Started : 03/22/2011 13:46:34
Last Updated : 03/22/2011 13:46:34
Global Time Limit : UNLIMITED
Per-SQL Time Limit : UNUSED
Number of Errors : 0

Analysis Information:
Before Change Execution:
After Change Execution:
Execution Name : before_change
Execution Type : TEST EXECUTE
Scope : COMPREHENSIVE
Status : COMPLETED
Started : 03/22/2011 13:45:55
Last Updated : 03/22/2011 13:45:55
Global Time Limit : UNLIMITED
Per-SQL Time Limit : UNUSED
Number of Errors : 0
Execution Name : after_change
Execution Type : TEST EXECUTE
Scope : COMPREHENSIVE
Status : COMPLETED
Started : 03/22/2011 13:46:24
Last Updated : 03/22/2011 13:46:25
Global Time Limit : UNLIMITED
Per-SQL Time Limit : UNUSED
Number of Errors : 0

Comparison Metric: ELAPSED_TIME
Workload Impact Threshold: 1%
SQL Impact Threshold: 1%

Report Summary

Projected Workload Change Impact:
Overall Impact : 99.36%
Improvement Impact : 99.36%
Regression Impact : 0%

SQL Statement Count
SQL Category SQL Count Plan Change Count
Overall 6 5
Improved 5 5
Unsupported 1 0

Top 5 SQL Sorted by Absolute Value of Change Impact on the Workload

object_id

sql_id
Impact on
Workload
Execution
Frequency
Metric
Before
Metric
After
Impact
on SQL
Plan
Change
16 2j3dk2hcs8jq5 24.25% 1 5651 22 99.61% y
18 7k24y5pdhurxx 21.33% 1 4977 26 99.48% y
19 7m2wr4twzmrkm 18.98% 1 4458 52 98.83% y
20 7vbu3057r64r0 17.94% 1 4194 29 99.31% y
21 fbsgyfwt1q29p 16.85% 1 3930 19 99.52% y
Note: time statistics are displayed in microseconds