getResultSetPlan
Return the execution plan by resultId.
The rootNodeTitle is the name of this sqlText execution plan.
The resultId element can be obtained from the operation response returned from
executeSql,
executeNativeSql,
executeProcedure, or
executeSqlScript. The queryPlanRoot contains the root plan.
Only users with the ACCESS_TOOLS right can call this operation.
Location
/services/webservices/system/admin/execute/operations/
Request Elements
rootNodeTitle (optional): The name of this resultId execution plan. Defaults to Execution Plan.
resultId: The SQL or Script executed resultId.
Response Elements
queryPlanRoot:
• name: Query plan node name.
• type: Type of this query plan node.
• properties (optional): List of name-value pairs of properties for current node.
• children (optional): List of child nodes belonging to current node. This list is iterative to any depth.
properties (optional): Same as properties element, above.
children (optional), Same as children element, above; and so on.
Faults
RuntimeError: If an error occurs during execution.
Security: If the user does not have the ACCESS_TOOLS right and other appropriate privileges.