-
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
Salesforce Customer 360: A Comprehensive Overview & Advantages
Salesforce recently introduced Customer 360, a groundbreaking technology that provides companies with a unified, comprehensive view of their customers across all touchpoints in the rapidly…
How Salesforce Financial Services Cloud Solves Problems For FinTech Companies
Working in the financial services industry is not an easy-breezy thing to do. It is all about managing people’s wealth and helping them plan their lives, literally.…
Salesforce Engage | Propel Customer Engagement with Relevancy
Marketing without customer engagement is nothing more than an on-air commercial that nobody wants to see. Every day the competition is intensifying, and keeping customers…
Popular Salesforce Videos
Salesforce Business Analyst Training
In the 35th Episode of the #AskTheHulk series, Savitha Asked about how to switch to IT from Non-IT background. To this question, Shrey suggested that…
How to use Salesforce Data to drive producivity and greater data capture
How do you encourage and drive better quality data entry into Salesforce by Salespeople? How do you use that data to drive productivity and proactive…
Three Quick Wins With Pardot | Salesforce
Discover the full suite of B2B marketing automation tools to create meaningful connections, generate more pipeline, and empower sales teams to close more deals. See…
