4

DuckDB Operations and Performance

In this chapter, we dive into DuckDB operations and performance. We will explore some of the features and techniques that can help you understand and improve the speed and efficiency of your DuckDB workloads. We will start by discussing how DuckDB supports indexes to speed up queries on large tables, followed by exploring file operations on Parquet data files. During these explorations, we will cover how to analyze queries by looking at their query plans, as well as how we can use run-time profiling to inspect the timing and memory usage of our workloads.

We will also dive into working with timestamps, looking at the data types and features that DuckDB offers for handling times and time zones. We conclude ...

Get Getting Started with DuckDB 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.