Markus Winand

@MarkusWinand

SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of use-the-index-luke.com and modern-sql.com.

Vienna, Austria

winand.at

Joined August 2010

254 Following

9,349 Followers

Replies Reposts Media

Pinned
Markus Winand
@MarkusWinand
Jan 18, 2021
Teaching is about making students reach the same level of understanding as the teacher—but with less mental effort. This allows students to put their mental efforts into growing beyond their teachers.
Markus Winand
@MarkusWinand
Oct 8
rewritey.com "Rewrite multi-join SQL into faster plans. Analyze query shape and workload overlap to find reusable intermediates." Maybe worth a try if you have aggregating queries with many joins.
1
Markus Winand
@MarkusWinand
Oct 1
€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.com Learning timeless fundamentals always has a lasting effect * you also need to read it, which takes about 1 day ;)
sql-performance-explained.com
SQL Performance Explained - buy directly from the author with free delivery
SQL Performance Explained: Everything developers need to know about database performance by Markus Winand
Markus Winand
@MarkusWinand
Jun 25
New post: Structured Primary Keys For consistency and performance.
modern-sql.com
Structured Primary Keys
Structured primary keys prevent contradiction and perform better than surrogate keys
2
Markus Winand
@MarkusWinand
Jun 1
MariaDB 12.3.2 was released last week. It's the first "stable" version of the long-term supported (LTS = 3 years) 12.3 branch. An SQL dialect enhancement is the IS JSON predicate. Also: a bug I reported is fixed (MDEV-38835). All charts on modern-sql.com are updated.
1