Results of 1 - 5 of about 5 for Zonemaps (0.001 sec.)
- Indexing 12851
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...tors and computing aggregations use zonemaps. If a filter criterion (like WHERE column1 = 123 ) is in use, DuckDB can skip any row group whose min-max range does not c...., it can omit a block with a min-max range of 1000 to 2000 when comparing for = 123 or < 400 ). The Effect of Ordering on Zonemaps The more ordered the data within a column, the more valuable the zonemap indexes will be. For example, a column could cont... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Reading and Writing Parquet Files 8493
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...quet file, the filter will be pushed down into the scan, and can even be used to skip parts of the file using the built-in zonemaps. Note that this will depend on whether or not your Parquet file contains zonemaps. Filter and projection pushdown provide... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
- Guides 8346
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...ptimal performance What is the ideal hardware environment for DuckDB How to import data efficiently How to use indexes and zonemaps How to make join operations efficient What performance implications do Parquet files and (compressed) CSV files have How t... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- What's New in the Docs for 2.0 8199
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...ursive CTEs and better row-group pruning. Recursive CTEs and the blog post on how DuckDB runs them faster Min-max indexes (zonemaps) used for row-group pruning Storage Format v2.0 New database files use the v2.0.0 storage format by default. The format ad... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- File Formats 8034
- Handling Parquet Files DuckDB has advanced support for Parquet files, which includes directly querying Parquet files . When deciding on whether to query these files directly or to first load them to the database, you need to consider severa
...t Files Availability of basic statistics: Parquet files use a columnar storage format and contain basic statistics such as zonemaps . Thanks to these features, DuckDB can leverage optimizations such as projection and filter pushdown on Parquet files. The... - https://man.mtool.work/duckdb/2.0/guides/performance/file_formats.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work