-
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
What is workflow automation and what can it do for me?
The one thing you're guaranteed to find in every active instance of Salesforce.com is interaction. It is a given that your users will add,edit,and/or remove data…
Why Salesforce Apex Trigger is Unique?
What is Salesforce Apex Trigger? A trigger is a piece of code that executes automatically in response to a specific event, such as the creation…
The Growing Importance of Data Privacy in Software Development
A shared concern in today’s society especially for the new age companies and consumers as well as the government performing their duties is data privacy.…
Popular Salesforce Videos
Salesforce Summer ’22 Release | Flow Enhancement of Summer 22 Release with Example
Exceed your business goals with the Summer ’22 release by seamlessly integrating your data, finding meaningful insights, and building lifelong customer relationships. How to Use…
About Queueable Apex | Asynchronous Apex in Salesforce | Learn Salesforce Development
Queueable apex is an asynchronous apex method. It's similar to the @future method. By using this queueable interface, we can process an Apex that runs…
How a Veteran can Start Their Career in Salesforce?
Let's Understand how a veteran can start their career in Salesforce? Please watch the full video and like, share and comment. Shrey is a Chief…
