Day 1 spotlight! 🌟
🕘 9:00 – Hettie Dombrovskaya: Learn how to write efficient queries
🕜 13:30 – Josef Machytka: Learn everything about #PGBouncer
▶️ Don’t miss these!
#PostgreSQL #PGDay #PPDD #QueryOptimization #DatabasePerformance

1+N querys
blog.danwald.me/1n-querys?re...

#django #queryoptimization

Boosting RAG search relevance often starts with query optimization. Generating synthetic queries and re-writing user inputs are powerful techniques to significantly enhance result accuracy. Don't underestimate the input! 💡 #QueryOptimization 2/5

Avoid non-sargable queries! Applying functions to indexed columns forces full table scans, killing performance. Instead, use indexed computed columns or case-insensitive collations for efficient filtering. #QueryOptimization 4/6

AIMindUpdate News!
Struggling with slow queries? Observability provides constant, deep insight into query performance! Learn how to optimize for speed and efficiency. #Observability #QueryOptimization #DatabasePerformance

Click here↓↓↓
aimindupdate.com/2025/10/09/u...

2/ Vlad Mihalcea's guide leverages Releem to supercharge MySQL query performance for Spring Boot apps. 💪 #QueryOptimization

Monkey Tools' TimeSleuth allows you to time all the queries in your #BusinessIntelligence solution, or just specific queries using the Detailed Refresh option. ⏱ It provides a detailed list of the refresh times as it goes. Learn how at mkyt.ca/timesleuth

#Excel #PowerQuery #QueryOptimization

Thanks for the amazing work to the whole team!

Joint work between Università degli Studi della Basilicata (Enzo Veltri, Donatello Santoro, Dario Satriani) and EURECOM (Sara Rosato, Simone Varriale).

#SQL #DataManagement #QueryOptimization #AI #LLM #Databases #SIGMOD2025

Nice:

“Extensible Query Optimizers In Practice” [2024, PDF], Bailu Ding, et al (www.microsoft.com/en-us/resear...).

#RDBMS #DB #QueryOptimizer #Paper #eBook #Survey #Databases #QueryOptimization

🚀 Debugging Materialize with Materialize 🚀

Materialize now exposes source maps, mapping runtime metrics to high-level operators.

✅ Pinpoint bottlenecks
✅ Get EXPLAIN ANALYZE insights
✅ Tune TopK queries efficiently

Deep dive: bit.ly/3Eq2l4g

#databases #queryoptimization #Materialize

Guide to optimizing Oracle SQL via execution plans: fix full scans, joins, sorting with indexing & examples #queryoptimization

Queries slow down at scale—but they don’t have to.

Cole Bowden explains how we optimize query performance for TB-scale workloads using distributed query execution and smart shuffle optimization.

👉 youtu.be/Ue42afyaU_0

#DataEngineering #QueryOptimization #SQLPerformance

“Why SQLite Uses Bytecode”, D. Richard Hipp (sqlite.org/draft/whybyt...).

On HN: news.ycombinator.com/item?id=4020...

On Lobsters: lobste.rs/s/g2tl3w/why...

#SQLite #Databases #Compiler #AST #Bytecode #VirtualMachine #Parsing #QueryOptimization #ExecutionPlan #SQL

Philip P. will be speaking at #sqlsatBoston
SQL Server Memory Management. Memory clerks, and other creatures.

👇
⏰ Register soon to avoid being on the waiting list:
lnkd.in/enDxaxQk

#sqlsaturday #sqlserver #performancetuning #queryoptimization  #memorymanagement #azuresql

Steven Wright will be speaking at #sqlsatBoston
So you want to be a Tuner? An introduction to SQL Query Plans

👇
⏰ Register soon to avoid being on the waiting list:
https://lnkd.in/enDxaxQk

#sqlsaturday #sqlserver #performancetuning #queryoptimization  #azuresql