-
how can you optimize SOQL query to fetch data from Salesforce Database?
As a Developer, how can you optimize SOQL query to fetch data from Salesforce Database?
-
This discussion was modified 6 years ago by
Marziya.
-
This discussion was modified 5 years, 12 months ago by Forcetalks.
-
This discussion was modified 5 years, 12 months ago by Forcetalks.
-
This discussion was modified 6 years ago by
-
2 Replies
-
As Salesforce doesn’t save data in traditional way. Data of all tenants are in common table, so traditional Query
Use the Query Plan tool to optimise and speed up queries done over large numbers of records. View query plans for SOQL queries, SOSL searches, reports, and list views. If custom indexes are available for your organization, use query plans to help you decide when to request a custom index from Salesforce Support.For more details visit here-https://help.salesforce.com/articleView?id=code_dev_console_tab_query_editor_query_plans.htm&type=5
-
Avoid the inner Queries, follow the best practices
Log In to reply.
Popular Salesforce Blogs
Salesforce Work.com | Reopening With Confidence
The COVID-19 outbreak has challenged our society and businesses into adapting to a new normal, one where we are confined to our homes and work…
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…
Career Planning in Salesforce (CRM) | What Makes Salesforce Career so Lucrative?
Salesforce is a customer relationship management (CRM) platform that provides a range of tools and technologies for sales, service, marketing, and collaboration. A career in…
Popular Salesforce Videos
Why Are Some of The World’s Biggest Brands Transitioning Towards Headless? | Salesforce
With the advancement of headless architecture, consumers can now enjoy an omnichannel shopping experience. But that's not all that headless commerce has to offer. Leading…
How To Use Javascript Editor In Formstack Part 1 - Learn Salesforce Series By Algoworks
Learn how to integrate Javascript editor in Formstack in this Salesforce tutorial brought to you by Algoworks. In this video, you will learn how to-…
See how fast and easy you can make intuitive Salesforce solutions to your users with Cauzali.
Instead of coding or very complex flows use Cauzali. Place your Cauzali model everywhere in Salesforce including in the middle of a Flow. Price between…
