Tips to get best SQL performance. Covering all major SQL databases. https://xitter.cf/t.co/pPX9UrXm8p is my book.
Vienna, Austria
Joined April 2011
- Tweets4.9K
- Following3
- Followers53.5K
- Likes268
Pinned Tweet
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…
SQL Performance Tips retweeted
€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 ;)
SQL Performance Tips retweeted
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, ...
Short-Circuiting Correlated Subqueries in SQLite
emschwartz.me/short-circuiti…
Another look into PostgreSQL CTE materialization and non-idempotent subqueries
shayon.dev/post/2025/124/ano…
SQL Performance Tips retweeted
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…
SQL Performance Tips retweeted
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
SQL Performance Tips retweeted
Survey on performance optimization for database systems (2023)
researchgate.net/publication…
SQL Performance Tips retweeted
#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…
Collations are a wonderful feature.
They solve problems way beyond case-insensitive search: ignoring accents and "numeric" sorting ('10' > '2') are just two more examples.
However, they do have a performance impact as shown by this micro-benchmark:
thebuild.com/blog/2024/11/20…
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…
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…
SQL Performance Tips retweeted
At about this time of the day, I run my open-to-everyone trainings.
The last training this year is "SQL Performance Explained", for which I have one spot left. It starts Dec 2nd and is delivered in seven 2-hour long in-person sessions each Mon/Wed/Fri.
winand.at/sql-training/open-…
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…
SQL Best Practices Every Java Engineer Must Know
foojay.io/today/sql-best-pra…
[IMHO: not just Java Engineers]
SQL Performance Tips retweeted
In the meanwhile enjoy a discount for SQL Performance Explained if you don't have it yet: 15YrsAnniversary
Only valid when purchasing directly from me (not on Amazon, ...):
sql-performance-explained.co…
(but valid for all languages — see language selection at the top).