Task Information:
|
Workload Information:
|
||||||||||||
|
|
|
|
Before Change Execution:
|
After Change Execution:
|
||||||||||||||||||||||||||||||||||||
|
|
||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||
Comparison Metric:
ELAPSED_TIME
|
|||||||||||||||||||||||||||||||||||||
Workload Impact Threshold:
1%
|
|||||||||||||||||||||||||||||||||||||
SQL Impact Threshold:
1%
|
|||||||||||||||||||||||||||||||||||||
Overall Impact | : | 99.36% |
---|---|---|
Improvement Impact | : | 99.36% |
Regression Impact | : | 0% |
SQL Category | SQL Count | Plan Change Count |
---|---|---|
Overall | 6 | 5 |
Improved | 5 | 5 |
Unsupported | 1 | 0 |
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 |