Working with Work Tables and Work Table Indexes

To minimize disk contention, you can create a file group for the work tables and work table indexes and store the data files for the file group on a separate physical disk. After creating the file group, within the configuration settings, change from the primary file group name to the new file group name.

  To change the name of the work table and work table index file group:

  1. Launch Workbench, and log on to the FDM application.

  2. Select Tools > Configuration Settings.

  3. Select Options > Work Table File Group.

  4. In Name, enter a name, and click Save.

  5. Select Options > Work Table Index File Group.

  6. In Name, enter the name that you entered in step 4, and click Save.

  7. Click Close.

All work tables and indexes that are created and dropped during data processing are located in the new file group.

Note:

Work tables and indexes can be separated, but no significant increase in performance should be expected.