✓ No loaded language, vague sourcing, or framing detected.

Research on Query Optimization Using Language Models

Research conducted by Leis et al. revisits the challenges faced by query optimizers, particularly in join ordering, which is an NP-hard problem. An experiment demonstrated that a language model could be trained to produce query plans that outperform those generated by Postgres. The study also discusses the limitations of Postgres in estimating cardinalities and introduces the pg_hint_plan extension as a method to influence query optimization.