-
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 4 years, 10 months ago by
Marziya.
-
This discussion was modified 4 years, 9 months ago by
Forcetalks.
-
This discussion was modified 4 years, 9 months ago by Forcetalks.
-
This discussion was modified 4 years, 10 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
-
Avoid the inner Queries, follow the best practices
Log In to reply.
Popular Salesforce Blogs
Visualforce Basics | Salesforce Learning Guide
Visualforce is a powerful tool and a stimulating framework allowing developers to explain the interface component and to create sophisticated custom interfaces which will be…
Top 10 Salesforce Interview Questions with Answers
The success and prosperity of any modern business depend on its ability to communicate with customers and meet their demands. That is why efficient Customer…
Interactive Sales Quotes: Streamline Proposal Creation
Old-school Sales Quoting Process and its Challenges In the old-school quoting process, sales representatives would manually gather product information, pricing details, and discounts, often relying…
Popular Salesforce Videos
Introduction to Report and Dashboard in Salesforce | Salesforce Training Videos
A report is a list of records that meet the criteria you define. It's displayed in Salesforce in rows and columns, and can be filtered,…
Salesforce Billing - Digital Wallets and Alternative Payment Methods
THE GOAL: In this video, you will learn how to use Alternative Payment Methods and Digital Wallets with Salesforce Billing. BEFORE YOU BEGIN, KNOW THE…
Salesforce Trailhead 2020 - Queueable Apex - Challenge
Create an Queueable Apex class that inserts Contacts for Accounts. Create a Queueable Apex class that inserts the same Contact for each Account for a…