Re: __index returns truncated to one, why?

[Geoff Leyland <geoff_leyland@...>]

On 11/04/2014, at 10:44 am, Andrew Starks <andrew.starks@trms.com> wrote:

> Whenever I hear about avoiding temporary tables, I wonder if the
> concern is based on theory, micro benchmarking or real-world
> application problems.

I’ve just had a “real world” situation where reducing temporary table creation halved the time it took to perform a computation.  Granted, the original code was probably a bit wasteful with them, and algorithmic improvements made a bigger difference, but temporary tables were a measurable factor.