Non-Selective Queries and Data Skew
When a DataRaptor or an Integration Procedure is slow, we are often quick to blame it on OmniStudio, while the issue may often originate in the underlying queries we’re running. In this chapter, we will look at an example of when a query on an indexed field may run slower than one on a non-indexed field. We will explore the reasons and look at tools we can use for benchmarking and optimizing our queries. So, if a query on your DataRaptor times out, or when your debug log shows a query taking a long time, the tools and techniques described in this chapter may help.
In this chapter, you will learn about the following:
- Why the Salesforce platform is sometimes not able to leverage indexes, even in a query where they were used before
- Factors that make queries in DataRaptors selective and non-selective and how to maintain your query performance as your data volume grows
- How to use the Query Plan tool for query optimization ...
