Snowflake Performance: Search Optimization Service(Probe side & Build side concepts)

What is "Probe side" & "Build side" objects in JOIN queries ? 1. These concepts when understood we can definitely apply the Search Optimization Service(SOS) on top of the objects to accelerate the query performance. 2. This video would explain these concepts with a demo. 3. Going through the video would give insights about how applying SOS to probe side of the table can improve performance. 4. The improvement in performance w.r.t partitions scanned value post application of the SOS. 4. Identification of Build & Probe side objects. 5. Details about SOS i.e., how it can be applied, how to check the objects once applied, its tracking, etc..