© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
M. FerleSnowPro™ Core Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9078-1_5

5. Storage and Performance Concepts

Maja Ferle1  
(1)
Ljubljana, Slovenia
 

Snowflake provides unique data storage features such as micro-partitions, clustering, and search optimization that enable fast query execution on tables with large volumes of data. Much of this optimization is taken care of by Snowflake behind the scenes, away from the users. However, as a Snowflake user, you must understand how this optimization works so that you can apply the most efficient query techniques in the right circumstances.

This chapter describes micro-partitions ...

Get SnowPro™ Core Certification Companion: Hands-on Preparation and Practice now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.