SOQL query Plan Tool

Helloo Friends,

This Article is all about: SOQL Query Plan Tool.

Query Plan tool in the Developer Console can help speed up SOQL queries done over large volumes.

Use the Query Plan tool to optimize and speed up queries done over large volumes.

To enable the tool,

Open Developer Console

:

click Help > Preferences and set Enable Query Plan to true.

Capture1

Capture2

To use the tool, enter your query and click the Query Plan button in the Query Editor. The Query Plan window displays all query operations and the cost of each.

Capture3

Capture4

If your cost value above 1 mean that the query won’t be selective and it need to add more filters to make it more selective.

Please find the below link : how to make your SOQL query selective.

https://help.salesforce.com/apex/HTViewSolution?urlname=How-to-make-my-SOQL-query-selective&language=en_US

——————————————————————-

Amit..

to be continued….


Comments

One response to “SOQL query Plan Tool”

  1. Nice start bro 🙂 Welcome aboard…. Keep it up.

Leave a Reply

Your email address will not be published. Required fields are marked *