Partition Pruning - CI/CD Glossary Definition
Partition pruning is a query optimization where the engine skips entire partitions whose key range cannot satisfy the query’s filter, so it reads only relevant data. It is the main reason partitioning speeds up analytics.
Related guides
Columnar Storage - CI/CD Glossary DefinitionColumnar storage lays data out by column rather than row, so analytical queries read only the columns they ne…
Query Plan - CI/CD Glossary DefinitionA query plan is the step-by-step strategy a database picks to execute a SQL statement - which indexes, joins,…
Parquet - CI/CD Glossary DefinitionParquet is an open columnar file format for analytics - compressed, schema-aware, and splittable - the defaul…