Login
Roast topics
Find topics
Find it!
From:
Java, SQL and jOOQ.
(Uncensored)
subscribe
What performs better, SQL FILTER or CASE?
https://blog.jooq.org/the-performance-impact-of-sqls-filter-clause/
links
backlinks
Roast topics
Find topics
Roast it!
The standard SQL FILTER clause is "just" syntax sugar for an equivalent CASE expression in an aggregate function. This article shows which performs better on PostgreSQL 15
