2 ms·
From my experience with other databases my assumption for DuckDB is: - Using a raw query, a CTE or a view will have no impact at all on query performance - the
by simonw 3y ago
From my experience with other databases my assumption for DuckDB is:
- Using a raw query, a CTE or a view will have no impact at all on query performance - they'll be optimized down to exactly the same operations (or to a query plan that's similar enough that the differences are negligible)
- CTEs are mainly useful for breaking down more complicated queries - so not great for this example, but really useful the moment you start doing anything more complicated.
- Views are effectively persistent CTEs - they're great if you want to permanently "bookmark" more complex pieces of queries to use later.
I wrote a bit more about CTEs here: https://datasette.io/tutorials/data-analysis#ctes https://datasette.io/tutorials/data-analysis#ctes