-
How can we optimize SQL query to fetch data from Salesforce Database?
How can you optimize SQL query to fetch data from Salesforce Database?
-
1 Reply
-
As Salesforce doesn’t save data in traditional way. Data of all tenants are in common table, so traditional Query optimization query and technique will not work in this case, so there is no such tool available to optimize final generated SQL. We only have option to create SOQL which is optimized by custom inbuilt Force.com Query Optimizer.
In Summer14, Salesforce released Query Plan Tool to analyze how query is performing. With help of this tool, we can get an idea how we can change our query to perform better.
Log In to reply.
Popular Salesforce Blogs
Salesforce Twilio Integration: A Guide for Easy Integration
In this era, smartphones created a new revolution. It brings a novel approach to our communication habits. Today SMS is a valuable tool for sending…
How to use aura:set in Salesforce Lightning?
aura:set - <aura:set > is used to set the value of an attribute inherited from a parent component, event, or to set the value of…
ContentDocument and ContentVersion in Salesforce - An Overview
Salesforce provides a world of standard objects and relationships among them. All the standard objects have their layouts, functionalities and many settings which make them…
Popular Salesforce Videos
How to Report on the Reports in Your Salesforce Org
Do you want a list of all the reports in your Salesforce org? Would you like to see a list of reports and the last…
COVID-19 Impact on The Automotive Industry -Digitization With Salesforce Can be a Solution
Coronavirus is expected to create a physical contactless environment with an increased thrust on online assessment and buying of vehicles. This is a huge shift…
Salesforce Chatter Tutorial | Chatter Overview And Demo | Chatter In Salesforce
This Salesforce Chatter Tutorial will give an overview of Chatter which includes enabling chatter, configuring chatter groups and creating customer groups. Salesforce Chatter will be…