duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html

Preview meta tags from the duckdb.org website.

Linked Hostnames

10

Thumbnail

Search Engine Appearance

Google

https://duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html

Sorting on Insert for Fast Selective Queries

Sorting data when loading can speed up selective read queries by an order of magnitude, thanks to DuckDB's automatic min-max indexes (also known as zone maps). This approach applies to most columnar file formats and databases as well. This post unpacks the DuckDB file structure as an example of a columnar data format and gives practical advice for using sorting to improve the speed of queries.



Bing

Sorting on Insert for Fast Selective Queries

https://duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html

Sorting data when loading can speed up selective read queries by an order of magnitude, thanks to DuckDB's automatic min-max indexes (also known as zone maps). This approach applies to most columnar file formats and databases as well. This post unpacks the DuckDB file structure as an example of a columnar data format and gives practical advice for using sorting to improve the speed of queries.



DuckDuckGo

https://duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html

Sorting on Insert for Fast Selective Queries

Sorting data when loading can speed up selective read queries by an order of magnitude, thanks to DuckDB's automatic min-max indexes (also known as zone maps). This approach applies to most columnar file formats and databases as well. This post unpacks the DuckDB file structure as an example of a columnar data format and gives practical advice for using sorting to improve the speed of queries.

  • General Meta Tags

    13
    • title
      Sorting on Insert for Fast Selective Queries – DuckDB
    • charset
      utf-8
    • viewport
      width=device-width, initial-scale=1.0, maximum-scale=1.0
    • msapplication-TileColor
      #000000
    • msapplication-config
      /images/favicon/browserconfig.xml

  • Open Graph Meta Tags

    7
    • og:title
      Sorting on Insert for Fast Selective Queries
    • US country flagog:locale
      en_US
    • og:description
      Sorting data when loading can speed up selective read queries by an order of magnitude, thanks to DuckDB's automatic min-max indexes (also known as zone maps). This approach applies to most columnar file formats and databases as well. This post unpacks the DuckDB file structure as an example of a columnar data format and gives practical advice for using sorting to improve the speed of queries.
    • og:url
      https://duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html
    • og:site_name
      DuckDB

  • Twitter Meta Tags

    3
    • twitter:card
      summary
    • twitter:site
      @DuckDB
    • twitter:creator
      @__AlexMonahan__

  • Link Tags

    9
    • alternate
      https://duckdb.org/feed.xml
    • apple-touch-icon
      /images/favicon/apple-touch-icon.png
    • canonical
      https://duckdb.org/2025/05/14/sorting-for-fast-selective-queries.html
    • icon
      /images/favicon/favicon-32x32.png
    • icon
      /images/favicon/favicon-16x16.png

Links

44