Given any SOQL query (which for the sake of this question we can assume doesn't use apex bind variables), how can I determine things like what indexes (if any) are being used, and if the query is selective?
asked Jul 21, 2015 at 20:14
Add a comment
|
1 Answer
There's a feature for doing just this in the salesforce REST API. In short, you hit the endpoint https://pod.salesforce.com/v34.0/query/?q={your URL encoded query} and it will return JSON describing query plans, relative cost, etc.
If you don't feel like invoking the REST API directly you can also do this from the developer console with a nice interface. However the feature is well hidden, you first need to go to the Help > Preferences menu in the developer console and check Enable Query Plan.
Once this is done the Query Editor tab in the bottom of the dev console will have a new button enabled: "Query Plan", next to the normal Execute button.
Enter your query and press this and you'll get all the data the REST API would provide, but in a nice graphical format:
answered Jul 21, 2015 at 20:14