In what order does a Saved Search evaluate criteri...
# ask-stanley-ai
r
In what order does a Saved Search evaluate criteria?
c
AI generated answer (using internal Slack threads):
The order of criteria in a Saved Search does not affect the performance. When you run a Saved Search, NetSuite converts it into an Oracle DB SQL statement. The Oracle query optimizer then determines the best plan for executing the search, regardless of the order in which you've listed the criteria. In other words, whether you list 'Total > $100' as the first criteria and 'Date == Yesterday' as the second, or vice versa, the performance of the search should be the same. The optimizer will evaluate all criteria simultaneously, not sequentially, to find the most efficient way to return the desired results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838485777
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.816931248
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815466881
Please provide your feedback on this answer.