-
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
Data Loader in Salesforce - Learn All About it Here
Data Loader is a platform which helps us with the mass import or export of data. It allows us to insert, update, delete, or export…
Artificial Intelligence in Salesforce Einstein - An Overview
To begin with artificial intelligence, it is the branch of computer science that focuses on the development of machine intelligence which makes machines work like…
Visualforce Basics | Salesforce Learning Guide
Visualforce is a powerful tool and a stimulating framework allowing developers to explain the interface component and to create sophisticated custom interfaces which will be…
Popular Salesforce Videos
Education Cloud in Salesforce
Education Cloud is a leading platform that empowers your institution to become a Connected Campus, so you can transform the student journey. With the power…
Navy Veteran Turned Solution Engineer Working at Salesforce
In this video, you know how a navy veteran turned Solution Engineer working at Salesforce. This is really inspiring for everyone. The video covered the…
How To Create Global Picklist In Salesforce
Learn how Global Picklist is created in Salesforce. The following points will be covered in this tutorial - 1. Introduction To Global Picklist Global picklist…
