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.
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.