LLM-Guided Database Query Optimization

Together AI is exploring the application of LLMs to optimize database query execution plans. This involves developing harnesses like DBPlanBench to expose query execution processes to LLMs, enabling them to analyze and suggest rewrites to improve performance. The approach focuses on semantic reasoning over statistical estimation, using techniques like JSON patching for targeted edits and evolutionary search for iterative refinement. The goal is to enhance query performance and reduce resource consumption, with a practical workflow for transferring optimizations from smaller scale factors to larger ones.