page182
268
testing is crucial to both proving performance benefits and for controlling costs.
No investigation would be complete without discussing the timeliness of search
access path maintenance and the implications of high-velocity DML changes to the
source table.
Finally, we offer a best-practice guide summarizing the optimal patterns where SOS
provides the most benefit.
For your further investigation, you may find these articles helpful:
•
https://community.snowflake.com/s/article/Search-
Optimization-When-How-To-Use
•
https://community.snowflake.com/s/article/Search-
Optimization-When-How-To-Use-Part-2
•
https://community.snowflake.com/s/article/Search-
Optimization-When-How-To-Use-Part-3
Drawing our investigation into SOS to a close, you will now investigate how to
improve the data pipeline processing speed by parallelizing your code.
Chapter 7
SearCh OptimizatiOn ServiCe