2 ms·
If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.
by wvenable 2y ago
If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.
- RaftPeople 2y agoI use them on purpose to "help" the optimizer by reducing the search space for query plan ((knowing that query plan optimization is a combinatorial problem and the optimizer frequently can't evaluate enough plans in a reasonable amount of time).