Top 10 SQL Performance Tips 3

“increase temp table size in a data warehousing environment (default is 32Mb) so it doesn’t write to disk (also constrained by max_heap_table_size, default 16Mb)”

Data working faster in memory process not in disk write mode.

Nowadays many linux livecd distro created to gain that benefit, more memory more speed icon smile Top 10 SQL Performance Tips 3

in windows try to find this value on file named my.ini