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
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…
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.
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…
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-…
Well, then read the article to see that it does make a big difference. use-the-index-luke.com/sql/c…
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…