This content describes an older version of this product.
View Latest
Query Performance
To optimize performance, learn how to structure your query to take advantage of the
different stages a SAQL query passes
through.
These topics explain common query performance problems and will help you write more
efficient queries.
Projection is Important
See how changing the order of the functions in your query can give remarkable performance improvements.
Network Traffic and Latency
You might not think there’s much you can do about network latency, but there are ways to reduce traffic.
Redundant Filters
Is your query doing more work than it needs to? Check to see if you have redundant filters.
Use the ELT Process
Is your dataset set up correctly for what you’re trying to do? You could be doing unnecessary work in your queries.
Multi-Value Dimensions
If you use picklists, and find your queries are slow, consider the impact of multi-value dimensions.
Limit the use of Unique()
Sometimes you need to use unique() in a query, but be aware that it can affect performance if there is a large number of unique values.
j