A little while ago we wrote an article titled “Developing Selective Force.com Queries through the Query Resource Feedback Parameter Beta” that explains how to use the query resource feedback parameter to analyze and tune your SOQL queries.
We’ve made some updates to this article to include details on new features added for the Spring ’15 release. In the Spring ‘15 release, you can also enter report and list view Ids into the Query Resource Feedback Parameter to test the selectivity of reports and listviews. An additional feature is a set of notes from the query optimizer including whether a field is un-indexed or if an un-optimizable operator is being used.
- Developing Selective Force.com Queries through the Query Resource Feedback Parameter Pilot
- Architect Core Resources
About the Author
John Tan is an Architect Evangelist within the Technical Enablement team of the salesforce.com Customer-Centric Engineering group. The team’s mission is to help customers understand how to implement technically sound salesforce.com solutions. Check out all of the resources that this team maintains on the Architect Core Resources page of Salesforce Developers.