Thats it! Pretty simple eh?
Summary The upshot is that you can realize roughly a 33% performance gain and not experience the blocking which is difficult to quantify due to the specificity of each application. Basically, you cannot lose. Solution in pseudo-code If you have an application that creates the same temp table many times within one connection, here’s how to convert it to reduce and reuse temp table creations. Raymond Lew has supplied a detailed example for trying this.
