Joined April 2011
- Tweets 4,943
- Following 2
- Followers 53,811
- Likes 267
167 Photos and videos
Pinned Tweet
11 Jan 2019
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…
8
56
146
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…
1
12
1,114
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.
1
9
1,651
Completley free web-book about SQL indexing:
use-the-index-luke.com/
Covering many systems such as MySQL, PostgreSQL, Oracle, ...
22
167
11,654
25 Nov 2025
Another look into PostgreSQL CTE materialization and non-idempotent subqueries
shayon.dev/post/2025/124/ano…
3
8
1,485
SQL Performance Tips retweeted
25 Oct 2024
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…
3
1
16
2,939
SQL Performance Tips retweeted
5 Sep 2025
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
1
5
1,512
SQL Performance Tips retweeted
11 Dec 2024
Survey on performance optimization for database systems (2023)
researchgate.net/publication…
5
15
2,700
SQL Performance Tips retweeted
8 Dec 2024
#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
2
9
2,447
3 Dec 2024
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…
7
1,623
22 Nov 2024
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…
2
6
23
2,501
22 Nov 2024
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…
1
3
1,308
22 Nov 2024
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…
1
1,155
SQL Performance Tips retweeted
6 Nov 2024
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-…
3
9
2,083
2 Oct 2024
SQL Best Practices Every Java Engineer Must Know
foojay.io/today/sql-best-pra…
[IMHO: not just Java Engineers]
3
11
1,863
SQL Performance Tips retweeted
31 Aug 2024
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).
5
15
2,285
SQL Performance Tips retweeted
29 Aug 2024
Learn once, benefit forever.
These SQL courses take experienced developers a leap forward. Starting on September 10th!
winand.at/en/newsletter/2024…
1
8
21
5,166
SQL Performance Tips retweeted
20 Mar 2024
The WITH clause is useful to write readable SQL.
modern-sql.com/use-case/lite…
9
30
3,898