BestHub
Sign in
DeepHub IMBA
DeepHub IMBA
Mar 17, 2026 · Artificial Intelligence

Advanced RAG Techniques: Boosting Retrieval with Query Translation and Decomposition

The article examines how retrieval‑augmented generation suffers from poor query formulation and presents two advanced strategies—query translation, which generates multiple semantically similar variants, and query decomposition, which breaks complex questions into finer sub‑queries—detailing methods such as fan‑out retrieval, reciprocal rank fusion, HyDE, step‑back prompting, and chain‑of‑thought retrieval, and explains when to combine them.

Hybrid RetrievalLLMQuery Decomposition
0 likes · 9 min read
Advanced RAG Techniques: Boosting Retrieval with Query Translation and Decomposition
Programmer DD
Programmer DD
Jul 14, 2022 · Databases

Why MySQL Joins Lag Behind PostgreSQL and How to Optimize Multi‑Table Queries

This article examines MySQL’s limited join capabilities compared to PostgreSQL, explains why multi‑table queries over three tables can be inefficient, and explores strategies such as service‑layer joins, query decomposition, and caching to improve performance and scalability in database‑centric applications.

JOIN optimizationMySQLQuery Decomposition
0 likes · 9 min read
Why MySQL Joins Lag Behind PostgreSQL and How to Optimize Multi‑Table Queries