From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Running point lookup queries on search-optimized tables

Running point lookup queries on search-optimized tables - Snowflake Tutorial

From the course: Advanced Snowflake: Deep Dive Cloud Data Warehousing and Analytics

Start my 1-month free trial Buy for my team

Running point lookup queries on search-optimized tables

“

- In this demo, we'll work with the search optimization service which can be used to improve the performance of selective point lookup queries on tables. Search optimization is a table level property and can be enabled for the table as a whole, and it applies to all columns in a table. Now, before we get to search optimization I'm going to change the current session to not use use cached results. USE_CACHED_RESULT I set to false. This is so that we can clearly identify and isolate the improvements in our query performance due to search optimization from any caching related improvements. In order to apply search optimization let's create a brand new table. This table is going to be called IOWA_SALES_OPTIMIZED and we'll populate this table using all of the records from the original IOWA_SALES table. So we create or replace table IOWA_SALES_OPTOMIZED by selecting star from IOWA_SALES. Applying search optimization on any…

Contents