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 by looking at how window functions can be used to efficiently process time-series data.
The chapter’s exploration of these topics is structured as follows:
- Exploring DuckDB indexes
- Optimizing file read performance of DuckDB...
