skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Explain Plan
 

Try DataDirect Cloud Now

Explain Plan

Purpose

The Explain Plan statement is supported for Salesforce-type, Microsoft Dynamics CRM Online, Oracle Marketing Cloud, Oracle Service Cloud, Progress Rollbase, Google Analytics, and SugarCRM data stores. The Explain Plan statement can be used with any query to retrieve a detailed list of the elements in the execution plan. Explain Plan generates a result set with a single column named OPERATION. The individual elements that comprise the plan are returned as rows in the result set.

Syntax

EXPLAIN PLAN FOR {SELECT ... | DELETE ... | INSERT ... | UPDATE ...}
The returned list of elements includes the indexes used for performing the query and can be used to optimize the query.