Comment by wvenable
1 year ago
If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.
1 year ago
If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.
I 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).