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

KeyDatatypeRequiredDescription
sqlObjectIdstring(Required) The SQL object ID for the SQL tuning task. This is not the OCID.
executionIdstring(Required) The execution ID for an execution of a SQL tuning task. This is not the OCID.

HEADERS

KeyDatatypeRequiredDescription
opc-request-idstringThe client request ID for tracing.
opc-named-credential-idstringThe OCID of the Named Credential.
Acceptstring

RESPONSES

status: OK

{&quot;original&quot;:{&quot;planType&quot;:&quot;\u003cstring\u003e&quot;,&quot;planStats&quot;:{&quot;quis_f&quot;:&quot;\u003cdouble\u003e&quot;,&quot;officia6ce&quot;:&quot;\u003cdouble\u003e&quot;,&quot;ipsum_6&quot;:&quot;\u003cdouble\u003e&quot;},&quot;planStatus&quot;:&quot;PARTIAL&quot;},&quot;modified&quot;:{&quot;planType&quot;:&quot;\u003cstring\u003e&quot;,&quot;planStats&quot;:{&quot;cupidatat_5&quot;:&quot;\u003cdouble\u003e&quot;,&quot;eu875&quot;:&quot;\u003cdouble\u003e&quot;},&quot;planStatus&quot;:&quot;COMPLETE&quot;}}