temp dbspace

Hi, On Tue, 25 Nov 2003 Art S. Kagel wrote: > DBSPACETEMP temp_dbs # Default temp dbspaces > Most sequential scans result in a sort to satisfy an ORDER BY or GROUP BY clause so if you have three or more temp > dbspaces >> listed above (or if you set the PSORT_NPROCS=12 (or more) and PSORT_DBTEMP=<list of 3-6 filesystems> in the >> environment) the improved sort speed can dramatically improve user performance perceptions. >> Also it's a good idea to list at least one 'normal' (not temp) dbspace in DBSPACETEMP so that logged temp tables >>have a place to go instead of the ROOTDB space which is critical to performance. List a low load dbspace, >> preferably on a different disk structure than the ROOTDB, logical & physical logs and other high activity chunks, >> that is NOT a temp space for this. WHY using three or more temp dbspace improve performance ? Thanks, Rein