Logo
Picture

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
    267
SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

4 months ago

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-minute-quiz

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

5 months ago

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.

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

5 months ago

Completley free web-book about SQL indexing: use-the-index-luke.com Covering many systems such as MySQL, PostgreSQL, Oracle, ...

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

6 months ago

Short-Circuiting Correlated Subqueries in SQLite emschwartz.me/short-circuiti…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

7 months ago

Another look into PostgreSQL CTE materialization and non-idempotent subqueries shayon.dev/post/2025/124/…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years 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…

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

9 months 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

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

2 years ago

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

SQL Performance Tips retweeted
_backslashzero Profile Picture

Shreyansh Gupta @_backslashzero

2 years 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

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years 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…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

Farm to TABLE: Local(e) Providers thebuild.com/blog/2024/11/1… The Doom That Came To PostgreSQL: When Collations Change thebuild.com/blog/2024/11/1…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

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/2… Speaking in Tongues: PostgreSQL and Character Encodings thebuild.com/blog/2024/10/2…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

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

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

2 years 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…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

@softilium Well, then read the article to see that it does make a big difference. use-the-index-luke.com/sql/clustering…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

@davidrowley_pg Check again :

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

3 years ago

Finding for the most recent, best matching, highest ranking rows (“Top-N”) is a common problem. The window functions ROW_NUMBER, RANK and DENSE_RANK can be used for such queries. Not all systems optimize these queries well—PostgreSQL 15 just learned it. use-the-index-luke.com/sql/partial-re…

SQLPerfTips Profile Picture

SQL Performance Tips @SQLPerfTips

2 years ago

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

SQL Performance Tips retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

2 years 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).

Trends for United States

$SPCX
$SPCX
#facebookdown
Robinhood
Fidelity
Elon Musk
Schwab
Cornyn
Midland
Nasdaq
Trillionaire
Facebook and Instagram
#BTS13thAnniversary
#FursuitFriday
Paraguay
#instagramdown
David Hockney
jikook
Happy 13th
Bosnia

You might like

The world's most popular open source database
MySQL
@MySQL
227K Followers
Microsoft SQL delivers a unified, secure SQL experience from ground to cloud, helping teams build AI‑ready, high‑performance applications anywhere.
Microsoft SQL
@SQLServer
259K Followers
Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.
Modern SQL
@ModernSQL
11K Followers
Daily Oracle SQL tips from the Oracle Developer Advocates for SQL
SQL Daily
@sqldaily
26K Followers
This is a group for MySQL developers/DBAs to expand their expertise, share ideas, and help develop better applications
MySQL Community Team
@mysql_community
16K Followers
SQL Server DBA, Owner/Founder at Stedman Solutions, LLC., Entrepreneur, Instructor, and Geek. Get your free SQL Joins poster here: https://t.co/ZEnsX3l1kp
Steve Stedman
@SqlEmt
10K Followers
A home for those who love JavaScript.
OpenJS Foundation
@openjsf
319K Followers
SQL Community led by SQL Server obsessives. We share knowledge around SQL, Azure & related technologies through our blogs, webcasts & in-person events.
SQLServerGeeks.com
@SQLServerGeeks
4K Followers
Available on-prem or in the cloud, #OracleDatabase enables you to simplify relational #database environments and reduce management workloads.
Oracle AI Database
@OracleDatabase
187K Followers
https://t.co/jx6SQIe84y is your one-stop shop for SQL Server consulting and training. Run by Paul Randal and Kimberly Tripp. Follow #sqlskills for team tweets!
SQLskills.com
@SQLskills
4K Followers
Grant Fritchey is a database geek, a Microsoft Data Platform MVP & AWS Community Builder. He works for Red Gate Software as a Product Advocate. Call: KC1KCE
Grant Fritchey
@GFritchey
15K Followers
SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Markus Winand
@MarkusWinand
9K Followers
Apache's one and only free & open source development environment, tooling platform, and application framework.
Apache NetBeans
@netbeans
60K Followers
Data & Analytics expert,
Kevin Kline
@kekline
11K Followers
Open Source Databases Run Better with Percona. Our expertise, software, services, and 24x7 support empower orgs to scale, optimize, and innovate w/o limits.
Percona
@Percona
16K Followers