-
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
The Salesforce Schema Builder — What You Need To Know
Keeping the pace of change is a constant challenge for systems and IT teams running Salesforce. Luckily, the platform comes with a ton of built-in…
Salesforce Spring '23 Release Overview
Salesforce is kick-starting the year with a whole host of updates in the Spring ’23 release, some of which we’ve outlined below! It's all about…
9 Reasons Why Sales Teams Struggle With Sales Results | Salesforce Guide
Sales. Yes, it is a tough job. One bad month and there are hundreds of questions to answer. No matter what the market reality is…
Popular Salesforce Videos
Salesforce Chatter Training - Staff
In this video, Kylee Durant provides a Salesforce Chatter Training overview, detailing how to enable and configure chatter groups, as well as create customer groups.
How Salesforce AppExchange Can Boost Your Application's Marketing ?
Explore the key benefits of AppExchange, the largest business app marketplace, and discover how you can tap into its vast ecosystem of potential customers. In…
Non Technical but Want to Build Career in Salesforce?
In this video Shrey gave the answer of the following questions: 1. What is the next step after doing Certification in Salesforce Administrator? 2. How…
