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.

Retrieval optimization using cached results

Retrieval optimization using cached results - Snowflake Tutorial

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

Start my 1-month free trial Buy for my team

Retrieval optimization using cached results

“

- Now that we've successfully loaded data into the Iowa Sales table, be ready to run queries on this table. This table contains records for the sales of different kinds of drinks across stores in Iowa. I'm going to run my very first Select Star from Iowa Sales. Now, because this is a large table, this query will take up to a minute to run. So you'll have to be a little patient. And once you get the results, let's take a look at how long it took for a query to execute. And if you click on the little cross at the bottom right of your screen you'll see that this query took about 44 seconds to run. And a total of 19.7 million rows were returned. Now this was a fairly simple query, no joints, no filtering, nothing, but you'll find that the Query Profile still holds some information for us. So let's open up the Query Profile and you'll find that there are two blocks in here. The bottom most block is the Table Scan…

Contents