Databases Reference
In-Depth Information
The
EVOLVE_SQL_PLAN_BASELINE
procedure returns a report, from which we can see if
the newly-generated execution plan passes the performance criterion. In other words, if it
performs better (comparing the compound improvement ratio) than the previous baseline,
it can be accepted.
The results of this operation can be seen in the following screenshot, which presents the
results obtained evolving our baseline. As we can see, the results with the new execution
plan are better than the previous baseline, so the execution plan is accepted:
In step 10, we drop the baseline, accessing by
SQL_HANDLE
, then drop the
MY_CUSTOMERS
table and revoke the grant from user
SH
.