------------ ---------------------------------------------
Execution Name : before_change Execution Name : after_change
Execution Type : TEST EXECUTE Execution Type : TEST EXECUTE
Scope : COMPREHENSIVE Scope : COMPREHENSIVE
Status : COMPLETED Status : COMPLETED
Started : 01/22/2014 16:23:18 Started : 01/22/2014 16:26:55
Last Updated : 01/22/2014 16:23:19 Last Updated : 01/22/2014 16:26:56
Global Time Limit : UNLIMITED Global Time Limit : UNLIMITED
Per-SQL Time Limit : UNUSED Per-SQL Time Limit : UNUSED
Number of Errors : 0 Number of Errors : 0
---------------------------------------------
Comparison Metric: ELAPSED_TIME
------------------
Workload Impact Threshold: 1%
--------------------------
SQL Impact Threshold: 1%
----------------------
Report Summary
---------------------------------------------------------------------------------------------
Projected Workload Change Impact:
-------------------------------------------
Overall Impact : -4.34%
Improvement Impact : 0%
Regression Impact : -4.34%
SQL Statement Count
-------------------------------------------
SQL Category SQL Count Plan Change Count
Overall 73 3
Regressed 1 0
Unchanged 61 3
Unsupported 11 0
Top 62 SQL Sorted by Absolute Value of Change Impact on the Workload
---------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------
| | | Impact on | Execution | Metric | Metric | Impact | Plan |
| object_id | sql_id | Workload | Frequency | Before | After | on SQL | Change |
-------------------------------------------------------------------------------------------
| 180 | 92putg43xhnmh | -4.34% | 27170 | 1368 | 4784 | -249.71% | n |
| 194 | ayps3qd9bp3xu | .96% | 27170 | 4043 | 3289 | 18.65% | n |
| 179 | 8pmg8j2t8jttn | -.59% | 27170 | 3350 | 3812 | -13.79% | n |
| 215 | ftyn8ab31suhy | .35% | 27170 | 3445 | 3172 | 7.92% | n |
| 192 | a9b7hza2pu8yg | .28% | 27170 | 2335 | 2118 | 9.29% | n |
| 217 | fwna046pnhkph | .22% | 27168 | 2402 | 2231 | 7.12% | n |
| 214 | fq6kgk88uu0zv | -.16% | 27170 | 1403 | 1526 | -8.77% | n |
| 212 | fhfnvc6xsd76s | -.15% | 27170 | 1317 | 1436 | -9.04% | n |
| 181 | 92t2p1mb77fd2 | .15% | 9020 | 2088 | 1743 | 16.52% | n |
| 151 | 0jjwuqsc83smj | .13% | 27170 | 2190 | 2088 | 4.66% | n |
| 210 | f0h101vrvjthv | .13% | 27170 | 3444 | 3342 | 2.96% | n |
| 202 | c8xam0hfncy67 | .12% | 27170 | 3442 | 3347 | 2.76% | n |
| 177 | 89nddu60j2tu8 | .11% | 27170 | 3337 | 3249 | 2.64% | n |
| 197 | bq0mtw261nykg | .09% | 27170 | 161 | 89 | 44.72% | n |
| 190 | a8fv3du19kn9d | -.07% | 27170 | 1335 | 1388 | -3.97% | n |
| 213 | fjfnf6b36nz1m | -.06% | 27168 | 779 | 828 | -6.29% | n |
| 208 | dbkpyhyfyvdpu | .06% | 27168 | 2213 | 2167 | 2.08% | n |
| 152 | 0km930j58nnd3 | .06% | 27170 | 2213 | 2168 | 2.03% | n |
| 184 | 9qtcjrzq4ts31 | .06% | 27170 | 3329 | 3284 | 1.35% | n |
| 150 | 0d8b21g2vh431 | -.05% | 27170 | 1344 | 1387 | -3.2% | n |
| 186 | 9u5j1q6fgvtwz | -.05% | 27170 | 1349 | 1392 | -3.19% | n |
| 158 | 23abq34mzxup7 | -.05% | 27170 | 2270 | 2310 | -1.76% | n |
| 216 | fvd0ndy3vfap6 | .04% | 27170 | 2293 | 2258 | 1.53% | n |
| 171 | 6s3r5jv7h0thu | .04% | 27170 | 2184 | 2151 | 1.51% | n |
| 165 | 414hfh2h265x0 | .04% | 27168 | 2284 | 2251 | 1.44% | n |
| 201 | c749bc43qqfz3 | -.04% | 148545 | 13 | 19 | -46.15% | n |
| 198 | brwggjwaurup3 | .04% | 27170 | 1384 | 1352 | 2.31% | n |
| 211 | f3zhdwhbw0k2f | .04% | 27168 | 2260 | 2229 | 1.37% | n |
| 206 | d48whvrkvucnn | -.03% | 27170 | 1325 | 1352 | -2.04% | n |
| 218 | fxgzgt3kj7j7r | -.03% | 27170 | 1327 | 1354 | -2.03% | n |
| 161 | 33bvu861qbr6k | -.03% | 27170 | 141 | 167 | -18.44% | n |
| 168 | 5k |