SQL Performance Explained — A Book For Developers.It focuses on what developers need to know. Just 200 pages…yet covering all major databases.

RT @MarkusWinand: Survey on performance optimization for database systems (2023).

RT @_backslashzero: #DoYouKnow? If your index is getting too big in size, you can index only a subset of the values using Partial Indexes.….

Improved RCSI Ghost Cleanup in SQL Server 2022.— by Paul White. As always, Paul provides deep insight into the SQL Server implementation.

Farm to TABLE: Local(e) Providers. The Doom That Came To PostgreSQL: When Collations Change.

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. Speaking in Tongues: PostgreSQL and Character Encodings.

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:.

RT @MarkusWinand: At about this time of the day, I run my open-to-everyone trainings. The last training this year is "SQL Performance Expl….

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)? .

SQL Best Practices Every Java Engineer Must Know. [IMHO: not just Java Engineers].

RT @AmelieBenoit33: TIL about Index-Only Scan for databases ✨. Also I'm in love with this website

RT @MarkusWinand: In the meanwhile enjoy a discount for SQL Performance Explained if you don't have it yet: 15YrsAnniversary. Only valid wh….

RT @MarkusWinand: Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th!….

RT @ModernSQL: The WITH clause is useful to write readable SQL.

There is currently some fuzz about the performance of subqueries vs with clause. Here is my take on it:.

This and much more is explained on Use The Index, Luke!.

What every developer should know about SQL performance. - Index/Query (mis)match.- The first power of indexing: finding data quickly.- The second power of indexing: clustering data.- The third power of indexing: sorting data.

RT @kotovr: Have finished reading the "SQL performance explained" book from @MarkusWinand (creator of the . Have a….

RT @MarkusWinand: Just announced new training dates. There are still seats left in my next performance training in April. The remaining co….

RT @SQLPerfTips: The Oracle DB maintains some information either on block or on row level ([NO]ROWDEPENDENCIES). .