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.
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.
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….
Leave a Reply