SOQL Query Plan Tool

-

SOQL Query Plan Tool


Salesforce provides its own query plan tool for our developers to increase the performance of SOQL queries.  

How to enable the Query Plan Tool in my Org?

- We can have the option to enable the Query plan tool in Developer Console.

Login to the org --> Open the Developer Console --> In the Developer Console menu, Go to Help --> Preferences --> Look for the "Enable Query Plan" option --> Then double click on its value and select the Checkbox. That's it the Query Plan would get enabled.



- That's it. Now we are able to see the Query Plan option while executing the SOQL query.


How to use the Query Plan Tool?

We can write any SOQL query and before executing the query, just click on the Query Plan button. We will get the detailed query analysis in the results section.


Here in the above screenshot, after running the Query Plan, we got the detailed plan details for the mentioned query.

Each Plan will contain information on Cardinality, Operation Type, Cost, sObject Type, and more. 

Each plan has a 'Leading Operation Type', for example, Field Index or Full Table Scan. 

The plan with the lowest cost is the plan that is used for driving the query execution.


Comments

Post a Comment

Popular posts from this blog

Apex Code Character Limit (Part I)

-
Image
Apex Code Character Limit What is Apex Code Character Limit? As we know, Salesforce works on a multi-tenant environment. So it provides common resources to every org. If we speak in terms of writing Apex code in our Org, due to multi-tenant architecture design, we do have a limit on code characters for every org.  That means, Salesforce literally counts each and every character that we use to write any code. This limit is called Apex Code Character Limit. The code character limit is almost the same for every org. As of now (after Summer'18 release), the code character limit would be 6 Million. This indicates that any developer can write and develop code in their org up to 6 Million characters. For suppose, if a developer has exhausted the provided code character limit, then an error would be thrown stating that " The total size of apex code in this application after removing comments exceeds the maximum character size of 6000000 ". So we cannot write ...
Read more

Deployment in Salesforce using Change sets

-
Image
Deployments in Salesforce Deployments in Salesforce Deployment is the migration of metadata changes between one Salesforce org to another Salesforce org. There are many tools available for Deployment in Salesforce. In this post, we will discuss about Changesets. To use the changesets feature, we need to enable the deployment connection in our org. This would specify the Inbound and Outbound changesets on the Deployment connections page. In Production org, Go to Setup → Type Deployment Settings → Then it will take us to the Deployment Settings page where, it will show the orgs that were connected to this Production org for deployment purpose. By the same way, if we check the Sandbox org “sfdemo1” also, we can be able to see the connected org for deployment as shown below, Sandbox org “sfdemo1” Now, we are going to deploy the things from Sandbox to Production. That means, we are developing the things in Sandbox and going to deploy the same in the Production org. So...
Read more

SFDX Developer Guide

-
Image
SFDX Developer Guide SFDX Developer Guide SFDX - Salesforce Developer Experience This doc explains the SFDX concepts in detail and it's solely based on my analysis and understanding. - Rajesh Babu Yanamala How to install SFDX on my machine? For Mac OS -  https://sfdc.co/sfdx_cli_osx For Windows 32-bit -  https://sfdc.co/sfdx_cli_win For Windows 64-bit -  https://sfdc.co/sfdx_cli_win64 Select the defaults, then install it in your machine. Once it's installed in our machine, then we need to verify whether it has been installed correctly. For that, we need to open the Command Prompt from our machine and type the command “ sfdx ” In order to check the version of the CLI, you can use the following command, sfdx --version -To see the installed plugins for SFDX CLI, then type this command, sfdx plugins To know the Salesforce version that's used in our CLI which you have installed, type this, sfdx force --ver...
Read more

REST API using Workbench

-
Image
REST API using Workbench We can use Workbench tool to test the REST API in any Salesforce org.  Let us discuss some popular scenarios to play with using Workbench tool in our Org. In order to play with Rest API, we need to login to our Salesforce org --> Then go to Workbench ( https://workbench.developerforce.com )  and --> Go to menu Utilities --> Select the REST Explorer . - After selecting the Rest Explorer, we would have so many HTTP methods to choose and to perform any action to our org. - Depending upon the requirement, we might use different methods at different scenarios. Some of the important methods as mentioned below, HTTP Method Description GET Retrieve data identified by a URL. POST Create a resource or post data to the server. DELETE Delete a resource identified by a URL. PUT Create or replace the resource sent in the request body. Scenario 1:  Fetch the complete list of objects in a salesforce org. - Just...
Read more

Customize Salesforce Login Page

-
Image
Salesforce Login Page Customization Bored with the standard Salesforce login page? Can we customize the login page as per our wish? The answer is YES . We can completely customize the Salesforce login page. - The primary requirement to do this step is to enable the MyDomain in our Salesforce org. - Say for example, in my demo org, I have setup my domain as  "zeebra-line-234-dev-ed.my.salesforce.com".  - Hence, my custom domain URL would become, https://zeebra-line-234-dev-ed.my.salesforce.com/   With this URL, I can be able to login to my demo org. - With the traditional login URL, https://login.salesforce.com we can be to login to any org by just giving the username and password. Once after logging into the org, we can be able to see the enabled custom domain URL on the browser header. We can customize the Salesforce branding and the right side frame. Here are the steps to do the same, Login to the org and go to Setup --> ...
Read more