Work-Area Disk Resources

During the data-staging process, the work area supports the use of two disk resources, the first for the staging tables and the second for the indexes created against the staging tables. However, stress testing indicates that splitting the table and index I/O to different resources may increase overhead. Therefore, using one disk resource for work tables and work table indexes is recommended.

ServerOption Key — Work-Area ResourceDefault Value
Oracleora_WorkTableSpaceUsers
ora_WorkIXTableSpaceUsers
SQL Server

FileGroupWorkTable

Primary

FileGroupWorkTableIndex

Primary