-
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 5 years, 11 months ago by
Marziya.
-
This discussion was modified 5 years, 10 months ago by Forcetalks.
-
This discussion was modified 5 years, 10 months ago by Forcetalks.
-
This discussion was modified 5 years, 11 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
How to Convert sforce.apex.execute to Lightning | Salesforce Developer Guide
Introduction In this blog, we will learn how to directly call the apex class through a custom button or javascript button on the object detail…
Salesforce Business Processes - Learn Here!
Salesforce is a leading customer relationship management (CRM) platform that helps businesses streamline and automate various processes. With its wide range of tools and features,…
How to Create AM Chart Using Salesforce Lightning Component?
Hi Friends, When I was learning AM Chart creation in salesforce lighting, I was facing lots of difficulties to implement this and for every AM…
Popular Salesforce Videos
Replicate Salesforce Data in Real-Time with Change Data Capture
In this video, we will see how to replicate Salesforce data Migrate your batch processing, scheduled ETL, and nightly workloads to event-driven, real-time integrations using…
Introduction to Salesforce Apex for Developers
Have you ever wanted to write a Trigger in Salesforce? This workshop is designed for people who would like to begin learning the basics of…
Product Rule Vs Price Rule Salesforce CPQ
Product Rule CPQ product rules help ensure sales reps are putting together the right products and bundles every single time. You don’t have to worry…
