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,600 courses taught by industry experts.

Clustering vs. search optimization

Clustering vs. search optimization - Snowflake Tutorial

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

Start my 1-month free trial Buy for my team

Clustering vs. search optimization

“

- [Tutor] Both search optimization and clustering improve the performance of queries that filter on certain predicates. Search optimization improves the performance of selective point lookup queries on all columns of the table, whereas clustering only applies to certain columns and it improves the performance of both point lookup queries, as well as range queries. In this demo, I'm going to run similar queries on a search optimized table and a clustered table, and we can compare the performance head on. Now, the table that we'll work with is a one from the "SNOWFLAKE_SAMPLE_DATA" database. This is the "Orders" table in the TPCH_SF100 schema. And it's a rather large table. This table holds around 4.3 gigabytes of compressed data. Let's take a look at what this table looks like. You can see that there are a number of different columns. O_CUSTKEY uniquely identifies customers for the different orders. I'll now create a new…

Contents