As someone who did a lot of SQL back in the day, and is now doing some again for a startup POC, I'd say you're basically right but there is also: * Rewriting q

As someone who did a lot of SQL back in the day, and is now doing some again for a startup POC, I'd say you're basically right but there is also: * Rewriting queries and also parts of the schema when it turns out the things that made sense in the design phase cause massive bottlenecks once you get more data, or just get it faster, than you tested with. Of course the good news is now you can run the best RDBMS's on your laptop, or on a $5/mo VPS; or have a small managed one starting at <= $15/mo. Plus ChatGPT can help you remember how to do that inside join. ;-)