-
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, 7 months ago by
Marziya.
-
This discussion was modified 6 years, 7 months ago by Forcetalks.
-
This discussion was modified 6 years, 7 months ago by Forcetalks.
-
This discussion was modified 6 years, 7 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
Is Salesforce a Lucrative Career Path?
Salesforce is "the world's #1 customer relationship management (CRM)," according to the website of the company. Their software is aimed to help organizations expand by…
What are Email Services In Salesforce? | The Ultimate Guide
Email services in Salesforce are also used for other purposes beyond email-to-case, such as processing inbound emails for custom objects, scheduling outbound email messages, and…
What is Multi-factor Authentication (MFA)? When and How to Use it? | Salesforce Developer Guide
What is Multi-factor Authentication (MFA)? Multi-factor authentication (MFA) is a secure authentication method that requires users to prove their identity by supplying two or more…
Popular Salesforce Videos
Introduction to Lightning Web Component - New Methodology to Develop Lightning Component
Lightning Web Components is the Salesforce implementation of that new breed of lightweight frameworks built on web standards. It leverages custom elements, templates, shadow DOM,…
Smart Merchandising with Salesforce Einstein AI
Smart Merchandising is a holistic tool that magically combines rich insights from site-wide search, navigation, purchases, and the customer’s current session with strategic business goals.…
Is the Salesforce Marketing Cloud the Future For Business?
As the market changes, one needs to keep up with the times. Companies are interested in Salesforce Marketing Cloud because it gives them a competitive…
