SQL Performance Tips @SQLPerfTips

Tips to get best SQL performance. Covering all major SQL databases. https://t.co/pPX9UrXm8p is my book. SQL-Performance-Explained.com/l/ Vienna, Austria Joined April 2011

Tweets

5K
Followers

54K
Following

2
Likes

269

Markus Winand @MarkusWinand

3 days ago

My favorite change is that MariaDB got an improved "WHERE year(...) = ?" rewriting. use-the-index-luke.com/blog/2024-12/d… 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

0 1 5 886 1

Download Image

Markus Winand @MarkusWinand

9 months ago

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

0 5 16 2K 11

Shreyansh Gupta @_backslashzero

9 months ago

#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/where-clau… #Databases #SQL

0 2 9 2K 2

SQL Performance Tips @SQLPerfTips

9 months ago

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/improv…

0 0 7 1K 2

Markus Winand @MarkusWinand

10 months ago

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/o…

0 3 9 2K 3

SQL Performance Tips @SQLPerfTips

11 months ago

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/clustering…

3 0 13 2K 5

Download Gif

SQL Performance Tips @SQLPerfTips

11 months ago

SQL Best Practices Every Java Engineer Must Know foojay.io/today/sql-best… [IMHO: not just Java Engineers]

0 3 11 2K 7

Amélie Benoit 🦋 @AmelieBenoit33

12 months ago

TIL about Index-Only Scan for databases ✨ Also I'm in love with this website use-the-index-luke.com/sql/clustering…

0 1 10 2K 2

Markus Winand @MarkusWinand

a year ago

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.com (but valid for all languages — see language selection at the top).

0 5 14 2K 5

Markus Winand @MarkusWinand

a year ago

Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th! winand.at/en/newsletter/…

1 8 21 5K 15

Modern SQL @ModernSQL

a year ago

The WITH clause is useful to write readable SQL. modern-sql.com/use-case/liter…

1 9 30 4K 13

SQL Performance Tips @SQLPerfTips

a year ago

There is currently some fuzz about the performance of subqueries vs with clause. Here is my take on it: modern-sql.com/feature/with/p…

0 7 38 5K 13

Roman Kotov @kotovr

2 years ago

Have finished reading the "SQL performance explained" book from @MarkusWinand (creator of the use-the-index-luke.com). Have already known about indexes and B-trees, but the book helped to understand how they affect SQL operations under the hood. Highly recommend!

1 3 18 2K 5

Markus Winand @MarkusWinand

2 years ago

Just announced new training dates. There are still seats left in my next performance training in April. The remaining courses take place in fall. winand.at/sql-training/o…