New Updates to Developing Selective Force.com Queries through the Query Resource Feedback Parameter
The "Developing Selective Force.com Queries through the Query Resource Feedback Parameter Pilot" article explores how to use the query resource feedback parameter to analyze and tune your SOQL queries. We've updated the article to include information on new Spring '15 features including report and listview support and the new optimizer notes information.
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.
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.