8 ms·
We've been focusing on indexing but query rewrites are probably next. It looks like LLMs can do a pretty good job at generating ideas, particularly if you prom
by jssmith 1y ago
We've been focusing on indexing but query rewrites are probably next.
It looks like LLMs can do a pretty good job at generating ideas, particularly if you prompt them right.
After that, you have to: 1/ make sure that the SQL produces the same results, 2/ see what the query planner will actually do with it, 3/ see whether it improves performance.
As you point out, the data makes a difference, so you need production data statistics, at a minimum, to do this well.