-
How can we optimize SQL query to fetch data from Salesforce Database?
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
Segments of Salesforce Data Cloud
Salesforce Data Cloud is a powerful platform that provides businesses with actionable data insights. Its features and architecture meet diverse business needs, making it a…
What are the Salesforce Marketing Cloud Three Essential Features?
Salesforce Marketing Cloud is the automation platform that receives the highest praise and boasts the greatest number of features of any product of its kind.…
Build a Sales Process in Salesforce | Learn How!
It is the process in which we can control the Picklist values of Stage field of Opportunity Object. We can create different sales processes for…
Popular Salesforce Videos
Salesforce Data Loader Tutorial
The Salesforce Data Loader is an easy to use graphical tool that helps you to get your data into Salesforce objects. The Data Loader can…
Field Level Security In Salesforce
Field-level security is a setting that lets Salesforce admins define user restrictions as to who can access specific org data. The setting lets the admin…
Using Salesforce as a Sales Rep | Salesforce Tutorials
Sales Rep Overview is for reps that own opportunities and carry a quota. Gain instant insight into your business over any time frame. Track won…