-
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, 10 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, 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
Salesforce Commerce Cloud: Delivering Innovation with a Difference
Dip in revenue, inconsistent customer experience, sluggish pace of operations and straight-jacketed scalability aren’t good for business, but when they become routine, the doom isn’t…
Salesforce Communities and Licenses
# BENEFITS OF COMMUNITIES: 1. Save Time By creating a community platform for customers to share, you give your customers access to not only your…
Keys to Improve Salesforce DevOps Efficiency
As indicated by the State of Modern Applications in Enterprises Report 2020, just 37% of big business respondents are happy with how quickly they are…
Popular Salesforce Videos
Being a Sr. Salesforce Consultant | SFDC Consultant Podcast
What it is like being a Sr. Salesforce Developer at a consulting firm. What a day in Sr. Salesforce Consultant's life looks like. Struggles of…
Stay Focused with Salesforce Customer 360
It's never easy to stay focused when distractions are pouring in from work, home, and everywhere in between. That’s why Salesforce Customer 360 helps business…
Salesforce Integration Using Oracle SOA Suite
In this video, Bristlecone gives an introduction to Oracle Cloud Adapter for Salesforce.com. Afterwards, he goes into detail about how to integrate Salesforce.com using Oracle…
