Print this page

Summer '15 - Retrieve Query Plans for Reports and List Views

Knowledge Article Number 000214276
Description In order to be able to use this feature (and use the Developer Console) you need the "View All Data" permission on your profile.

The first steps is to retrieve the report ID or the list view ID.
The ID can be found simply by copying the URL of the list view and copy the part after "fcf=" as per screenshot below, starting with 00B:
User-added image


You can retrieve the report ID simply by copying the part of URL starting with 00O as per screenshot below:
User-added image

If the report it timing out and you are unable to get the id, you can access it in edit mode as per screenshot below:
User-added image

and you will see the URL as: HTTPS://[yourinstance].salesforce.com/[reportID]/e
Resolution Once you have the list view or report ID, you need to access the developer console by clicking on Your Name > Developer console.

In order to enable the Query Plan button in the Query Editor, click Help  > Preferences then set Enable Query Plan to true and then click Save
User-added image

User-added image

In order to see the query plan, enter the report or list view ID in the Query Editor Tab, and then click on "Query Plan" button.
User-added image
This way you can check which field is used in the report, if a custom index is being used and the object where the field is located.

Please NOTE:
You can request a custom index to be created logging a support case, but you need to provide the report/list views ID and grant login access. If the field is selective enough we will proceed with the creation.
 




promote demote