-
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, 9 months ago by
Marziya.
-
This discussion was modified 6 years, 8 months ago by Forcetalks.
-
This discussion was modified 6 years, 8 months ago by Forcetalks.
-
This discussion was modified 6 years, 9 months 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
- [adinserter block='9']
-
Avoid the inner Queries, follow the best practices
Log In to reply.
Popular Salesforce Blogs
Most Essentials Tools for Building Salesforce Lightning Components
Any Salesforce developer who wants to be at the top of his game should know how to work well with Lightning Components. With Lightning Components,…
Explain the Top 10 Reasons to Choose Salesforce for your Business
What is Salesforce? Salesforce is a cloud-based software company that offers tools to businesses to help them find more prospects, close more deals, and provide…
Mistakes To Avoid During Salesforce Data Migration
Data is the foundation on which all CRMs are built: start with poor data, you’ll get poor returns. That’s why data migration is such a…
Popular Salesforce Videos
What is Approval Process in Salesforce?
Automated process that approves records for the organization and it can be defined with a sequence of steps. Watch the video to learn and if…
AMPscript Case Functions - Salesforce Marketing Cloud Functions in 5 minutes
Cameron Robert steps through how to use the Upper, Lower and Proper Case Functions in AMPscript. Cameron also takes a closer look at the ProperCase…
Send WhatsApp and Save Chat using Lightning Component Salesforce | Salesforce Tutorials
In this video you will learn to send #WhatsApp using Lightning Component Salesforce. Also we will create a custom object to store the chat. Features…
