-
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
Basics of Salesforce Admin and App Builder Certifications
A Salesforce Admin Certification is the most elevated type of acknowledgement a Salesforce Administrator can accomplish; it shows aptitude in the field just as a…
What are Auto-Launched Flows? | All You Need to Know
What are Auto-launched Flows? A certain event, such as the creation or updating of a record or the receiving of a platform event, can automatically…
Climate Change Effects on Business: 5 Reasons Why You Should Care About Sustainability
"We are running the most dangerous experiment in history right now, which is to see how much carbon dioxide the atmosphere can handle before there…
Popular Salesforce Videos
How to Become a Certified Salesforce Admin
It is predicted there will be 1.9m new Salesforce job openings by 2020. Consultants thinking of a career in IT should consider training in cloud…
How to Create a Jira Ticket from Salesforce?
Learn how to create a Jira ticket in Salesforce using two different methods and how to choose a Jira project. Know more at https://www.sinergify.com/
How to Use the Lightning Knowledge Migration Tool | Salesforce Tutorial
Use the Lightning Knowledge Migration Tool to move your Classic knowledge base into Lightning Knowledge. The Lightning Knowledge Migration Tool works differently depending on whether…
