3 ms·
Why would it be too expensive to optimize out static subexpressions?
by hinkley 2y ago
Why would it be too expensive to optimize out static subexpressions?
- jjice 2y agoMy guess is that the expense can be tricky to calculate since the additional optimization prior to executing the query may take longer than if the query was just able to run (depending on the dataset, of course). I wonder if it's too expensive to calculate a heuristic as well, so it just allows it to execute. Just a guess.