-
As a Developer, how can you optimize SQL query to fetch data from Salesforce Database?
As a Developer, 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
Trigger Assignment Rules on Update or Upsert using Data Loader | Salesforce Tutorials
Hello guys, In this article, we will do some work around Assignment Rules. As you are aware Assignment Rule can be trigger on Insert actions.…
What is Clone and Deep Clone in Apex?
Clone is the predefined method in Apex which is used to clone the record just by one functional line of code. Deep Clone is the…
Salesforce Integration : Streamlining Administrative Processes
In the dynamic world of business and education, administrative efficiency plays a vital role. Institutions, big or small, educational or corporate, require structured processes to…
Popular Salesforce Videos
How Does SFCC (Headless Commerce) Different From Its Competitors and Why Is It Better? | Salesforce
Let's have look at which one is better SFCC, Shopify, Magento, or Woocommerce. Which one you should choose? Have a glance at this extract from…
Interested to Learn Salesforce? But Unsure Where to Start?
Salesforce is a popular CRM tool for support, sales, and marketing teams worldwide. Salesforce services allow businesses to use cloud technology to better connect with…
Introduction to Programming | Live Salesforce Development
Learn Salesforce development from start to finish for free. Want to take your Salesforce Knowledge to the next level? Want to learn advanced Salesforce admin,…
