-
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…
Setting SSO Between Salesforce and Okta’s Salesforce.com Standard Application using SAML 2.0 protocol
SSO(Single Sign On between Okta(Salesforce.com application) as Identity Provider and Salesforce as Service Provider) Steps to setup SSO between Salesforce and Okta’s Salesforce.com Application:- Go…
Grant Account Login Access in Salesforce
Grant Account login access in Salesforce is a standard inbuilt salesforce feature. It might possible that sometimes you have queries or issues with salesforce itself or…
Popular Salesforce Videos
Create a LinkedIn Page like a Salesforce Professional
In this first video of our series "How to Find a Job as a Salesforce Professional", Brad discusses how to create and modify your outdated…
Introduction to Creating and Using Salesforce Reports
Every Salesforce user can benefit from working with Salesforce Reports. We often say that one of the best Salesforce features is that "...even mere mortals…
How To Use Javascript Editor In Formstack Part 1 - Learn Salesforce Series By Algoworks
Learn how to integrate Javascript editor in Formstack in this Salesforce tutorial brought to you by Algoworks. In this video, you will learn how to-…
