-
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
Learn All About Salesforce Managed Services vs In-house Team
The day-to-day operations of modern businesses depend on technology and cloud-based tools. With ever-changing IT needs and business configuration tools becoming more important, one small…
7 Signs Your Company Needs a Salesforce Consulting Partner
1. Struggling with Salesforce Adoption One of the most common challenges businesses face is low adoption rates of Salesforce among their teams. Despite its powerful…
Top Salesforce Trends to Watch Out in 2021
2020 year has been a challenging year for everyone no doubt. The pandemic, global lockdown, and economic crisis have affected everyone’s personal lives and the…
Popular Salesforce Videos
See the Future of APIs at Salesforce
Salesforce APIs are a way for other applications (or code in other applications) to programmatically access data within your Salesforce org, in a simple and…
Salesforce Consultant Career | Salesforce Career Path | Salesforce Consultant Certification
If you're interested in becoming a Salesforce consultant, one of the first things to consider is how much education you need. We've determined that 60.2%…
Different tools use to code in APEX | APEX Basics | Salesforce Development Course
Are you aware of the tools that are used for writing codes in APEX? Here are the different tools that you can use to write…