-
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
Why Should You Attend Salesforce Dreamforce 2019 & How To Make The Most Out Of It?
Dreamforce is a yearly conference that takes the full Salesforce people group composed. SF clients, workers, partners, and important partners gather in San Francisco over…
4 Major Advantages of Salesforce Einstein Analytics for Sales Managers
For many years, most of the Salesforce users were using reports and dashboards to quickly look up their data, perceive performance, and communicate results. But…
Learn About Lightning Design System in Salesforce
What is the Salesforce Lightning Design System? Should I use it? It's easy to forget the days before Bootstrap when web developers had to painstakingly…
Popular Salesforce Videos
What are Search Layouts in Salesforce?
In this video, Shrey is not only teaching but also demonstrating to you "What are Search Layouts in Salesforce". You will be learning: 1. How…
Who Should Use SFRA and PWA? | Salesforce Commerce Cloud
Different organizations need different architecture according to their needs. Organizations who want their website built on the latest technology and modern approaches can go towards…
How to Learn Salesforce in easy step by step and get certified
From Salesforce instructor, Become a Salesforce Expert. Learn Salesforce step by step and get certified easily.
