> However, decision support databases typically touch a lot more data per > statement (by scanning, sorting, prefetching, etc.) and are more likely to > make intelligent use of parallelism. Even then, you should leave the degree > set to -1 (automatic), since the optimizer doesn't usually pick a degree > that is higher than the number of installed CPUs.
Has anybody else been bitten by Hyperthreading with Linux and DB2? We had to turn off Hyperthreading at the BIOS in order not to confuse the optimizer, but has anybody actually gotten it to work correctly? IBM notes support for W2K for hyperthreading ( http://www-3.ibm.com/software/data/db2/windows/ ), but do they support it for Linux yet? -HJC - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
