Retrieve a comparison of the existing SQL execution plan and new plan.
GET {{baseUrl}}/managedDatabases/:managedDatabaseId/sqlTuningAdvisorTasks/:sqlTuningAdvisorTaskId/executionPlanStatsComparision?sqlObjectId=<long>&executionId=<long>
Retrieves a comparison of the existing SQL execution plan and a new plan. A SQL tuning task may suggest a new execution plan for a SQL, and this API retrieves the comparison report of the statistics of the two plans.
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
sqlObjectId | string | (Required) The SQL object ID for the SQL tuning task. This is not the OCID. | |
executionId | string | (Required) The execution ID for an execution of a SQL tuning task. This is not the OCID. | |
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
opc-named-credential-id | string | The OCID of the Named Credential. | |
Accept | string |
RESPONSES
status: OK
{"original":{"planType":"\u003cstring\u003e","planStats":{"quis_f":"\u003cdouble\u003e","officia6ce":"\u003cdouble\u003e","ipsum_6":"\u003cdouble\u003e"},"planStatus":"PARTIAL"},"modified":{"planType":"\u003cstring\u003e","planStats":{"cupidatat_5":"\u003cdouble\u003e","eu875":"\u003cdouble\u003e"},"planStatus":"COMPLETE"}}