-
As a Developer, how can you optimize SQL query to fetch data from Salesforce Database?
As a Developer, how can you optimize SQL query to fetch data from Salesforce Database?
-
1 Reply
-
As Salesforce doesn’t save data in traditional way. Data of all tenants are in common table, so traditional Query optimization query and technique will not work in this case, so there is no such tool available to optimize final generated SQL. We only have option to create SOQL which is optimized by custom inbuilt Force.com Query Optimizer.
In Summer14, Salesforce released Query Plan Tool to analyze how query is performing. With help of this tool, we can get an idea how we can change our query to perform better.
Log In to reply.
Popular Salesforce Blogs
6 Ways to Improve Salesforce Release Management
Salesforce was initially planned as a CRM. Be that as it may, it's become a mainstream improvement stage because of its natural usefulness. Salesforce uses…
Salesforce Marketing Cloud Custom Profile and Preference Centre
Custom Profile & Subscription Centre Working 1. Why we need Custom Profile & Subscription center In SFMC we have seen Preference/Profile center either from Email…
All You Need to Know About the Wrapper Class In Salesforce
A class, data structure, or abstract data type that has a variety of objects or collections of objects as members is known as a wrapper…
Popular Salesforce Videos
Permissions In Salesforce Experience Cloud Explained | Salesforce Communities
A permission set is a collection of settings and permissions that give users access to various tools and functions. Permission sets extend users' functional access…
Salesforce Consultant or Salesforce Admin First? | Which is Better?
In this video, Kaelan Moss - Minute Admin briefs us on whether it's better to be a Salesforce admin or consultant first. Watch the video…
Salesforce Financial Services Cloud Implementation Guide
You’ve decided to use Salesforce Financial Services Cloud but where do you begin? How can you utilize Salesforce to track all your customer interactions and…
