var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have the following scenario.STMM is off and sheapthres is set to 0.Is it true that sorts will take place in shared memory although STMM is off??Or is it that STMM has to be turned on for that to take into effect
STMM = OFF
Yes, you're correct. All sorts are in shared memory (db memory) if sheapthres=0. I believe this is regardless of what STMM is set to.
Last edited by db2girl; 03-01-09 at 13:18.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors