2 ms·
> 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 combina
by 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.