
SQL Performance Explained — A Book For Developers It focuses on what developers need to know. Just 200 pages…yet covering all major databases. sql-performance-explained.co…

Tips to get best SQL performance. Covering all major SQL databases. sql-performance-explained.co… is my book.

SQL Performance Explained — A Book For Developers It focuses on what developers need to know. Just 200 pages…yet covering all major databases. sql-performance-explained.co…

€10 for a frontier AI subscription are gone in one workday €10 for my book SQL Performance Explained has a lasting impact on you* sql-performance-explained.co… Learning timeless fundamentals always has a lasting effect * you also need to read it, which takes about 1 day ;)

New post: Structured Primary Keys For consistency and performance. modern-sql.com/blog/2026-06/…

14 years online, still relevant and current. Those who did the quiz 14 years ago can still benefit for their lessons at that time. use-the-index-luke.com/3-min…

A B-tree is not a binary tree. A B-tree does not go out of balance. A B-tree is self-balancing: it does *not* require expensive operations to keep the balance.

Completley free web-book about SQL indexing: use-the-index-luke.com/ Covering many systems such as MySQL, PostgreSQL, Oracle, ...


Another look into PostgreSQL CTE materialization and non-idempotent subqueries shayon.dev/post/2025/124/ano…

For this WHERE, what index to create? WHERE subsidiary_id = 42 AND last_name LIKE '%INA%' Is (subsidiary_id) enough or should it be (subsidiary_id, last_name)? use-the-index-luke.com/sql/c…

My favorite change is that MariaDB got an improved "WHERE year(...) = ?" rewriting. use-the-index-luke.com/blog/… In picture: the green check mark used to be yellow, with the "a" footnote: Unconditionally rewritten—even if only a matching function-based index exists

Survey on performance optimization for database systems (2023) researchgate.net/publication…

#doyouknow? If your index is getting too big in size, you can index only a subset of the values using Partial Indexes. Read more here - use-the-index-luke.com/sql/w… #databases #sql

Improved RCSI Ghost Cleanup in SQL Server 2022 — by Paul White As always, Paul provides deep insight into the SQL Server implementation. sql.kiwi/2024/12/improved-gh…

Farm to TABLE: Local(e) Providers thebuild.com/blog/2024/11/14… The Doom That Came To PostgreSQL: When Collations Change thebuild.com/blog/2024/11/15…

If you are not sure what collations are about, please read the entire series by Christophe Pettus: “Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales thebuild.com/blog/2024/10/25… Speaking in Tongues: PostgreSQL and Character Encodings thebuild.com/blog/2024/10/27…

As sort-based indexes (such as B-Tree) also use collations to establish their row order, the speed of the collation affects the index build time, but not so much the search time as the number of comparisons for a search is very limited.