This flowchart diagram shows the SQL Tuning Advisor APIs.
The following SQL Tuning Advisor API procedures are shown:
Starting from the top of the diagram, STS leads to the
CREATE_TUNING_TASK procedure, which leads to
REPORT_TUNING_TASK procedure is shown to only take place after execute and leads to four types of recommendations that user may choose to implement: store, SQL Profile, access, and rewrite.
End of image description.