zlacker

If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.

>>wvenab+(OP)
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).