3 ms·
User does not want to control optimizations. User wants their queries to run fast enough. Ideally database should monitor the queries and create/remove necessar
by vbezhenar 2y ago
User does not want to control optimizations. User wants their queries to run fast enough. Ideally database should monitor the queries and create/remove necessary indices as needed. And some databases do that.
- RaftPeople 2y ago> User does not want to control optimizations. It's true, it would nice if the user didn't need to intervene, but unfortunately query optimization is a combinatorial problem where the engine has incomplete information causing performance problems (or cost problems if you are on Snowflake), so the user is required to intervene some percentage of the time.