Work Locations
The SET WORK LOCATIONS statement adds, removes, or changes the set of locations that the DBMS Server uses for sorting.
Sorting can occur when:
• Queries are executed. This may be an ORDER BY or as part of the Query Execution Plan (for example, a Full Sort Merge Join).
• Tables or indexes are modified.
To add work locations to the set of locations currently in use, issue the SET WORK LOCATIONS ADD statement and specify the locations to be added.
To remove locations from the set of locations currently in use, issue the SET WORK LOCATIONS DROP statement.
To replace the set of locations currently in use, issue the SET WORK LOCATIONS USE statement.
Work locations are defined using the CREATE LOCATION statement, changed using ALTER LOCATION statement, and destroyed using the DROP LOCATION statement.
To issue the SET WORK LOCATIONS statement, the effective user of the session must have maintain_locations privilege. For more information see CREATE USER and ALTER USER.
For details about configuring your installation to improve the performance of sorting, see the Database Administrator Guide.