Get startedGet started for free

Query pruning with micro-partitioning

How does Snowflake use micro-partitions to improve query performance for the query below?

SELECT
    team,
    year,
    sport,
    event,
    medal
FROM olympic_medals
WHERE year >= 2000;  

This exercise is part of the course

Introduction to NoSQL

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise