10. Using Alternate Locations : Work Locations
 
Share this page                  
Work Locations
All databases use work files for sorting, joins, aggregations, and buffering and reusing of repeating query parts that spill to disk, which can occur when queries are executed. While small sorts are performed in memory, larger sorts use temporary sort files. Depending on the size of the tables involved in the sort, the temporary disk space requirements can be large.