SQL Performance Tips
@SQLPerfTips
Tips to get best SQL performance. Covering all major SQL databases. http://sql-performance-explained.com is my book.
Вам может понравиться
SQL Performance Explained — A Book For Developers It focuses on what developers need to know. Just 200 pages…yet covering all major databases. sql-performance-explained.com
Another look into PostgreSQL CTE materialization and non-idempotent subqueries shayon.dev/post/2025/124/…
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…
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
Survey on performance optimization for database systems (2023) researchgate.net/publication/36…
#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
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…
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…
SQL Best Practices Every Java Engineer Must Know foojay.io/today/sql-best… [IMHO: not just Java Engineers]
TIL about Index-Only Scan for databases ✨ Also I'm in love with this website use-the-index-luke.com/sql/clustering…
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).
Learn once, benefit forever. These SQL courses take experienced developers a leap forward. Starting on September 10th! winand.at/en/newsletter/…
The WITH clause is useful to write readable SQL. modern-sql.com/use-case/liter…
modern-sql.com
Literate SQL using the WITH clause
Complex queries are hard to read. Literate SQL is about writing queries that are as easy to read as a good novel.
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…
United States Тренды
- 1. Alina Habba 10.3K posts
- 2. Piers 27.2K posts
- 3. Wolves 80K posts
- 4. Chargers 15.2K posts
- 5. Paramount 75.1K posts
- 6. Cunha 12.2K posts
- 7. Carragher 31.2K posts
- 8. #WOLMUN 6,642 posts
- 9. Manchester United 37.4K posts
- 10. Farmers 75K posts
- 11. #NXXT_DOESupport N/A
- 12. Kyle 32K posts
- 13. Jermaine Burton N/A
- 14. #CHILISSKILLETQUESO 1,215 posts
- 15. Go Birds 6,283 posts
- 16. Jiffy Pop N/A
- 17. Jasmine Crockett 17.7K posts
- 18. Mbuemo 2,130 posts
- 19. Mbeumo 10.9K posts
- 20. NextNRG Inc. 3,133 posts
Вам может понравиться
-
MySQL
@MySQL -
Microsoft SQL Server
@SQLServer -
Modern SQL
@ModernSQL -
SQL Daily
@sqldaily -
MySQL Community Team
@mysql_community -
Steve Stedman
@SqlEmt -
OpenJS Foundation
@openjsf -
Planet PostgreSQL
@planetpostgres -
SQLServerGeeks.com
@SQLServerGeeks -
Oracle AI Database
@OracleDatabase -
PHP Classes of Objects and Global Code Scripts
@phpclasses -
Grant Fritchey
@GFritchey -
Markus Winand
@MarkusWinand -
Apache NetBeans
@netbeans -
Kevin Kline
@kekline
Something went wrong.
Something went wrong.