Query Optimization has been a crucial and headache issue for SQL storage engines. Databricks, Snowflake, Microsoft, and Oracle all have big teams dedicated to this field. Meanwhile, insufficient SQL queries are still everywhere and wasting tons of time and computing resources. Currently, there are various ways to rewrite an inefficient SQL query, there are even startups just to help you write good queries. But their approaches are still mostly by rules and heuristics. ChatGPT is able to rewrite some queries, but firstly the current results are not good enough, and secondly, it would be hard to incorporate data schema information such as table, index, etc. However, these obstacles are not unsolvable. We should believe LLM can play a bigger role in this field. This project leverages the power of PaLM and LangChain, demonstrating the first step towards this goal.
šš» Be the first to build an AI App on Google's models! Hackathon on July 7-10. š¬š Try new Vertex AI features from Google Cloud Platform. š¤š Learn from AI leaders and connect with like-minded people. š ļøš± Build apps with the world's best AI tools! š”š Solve real-world problems with Generative AI models