Optimizing Sort Operations

After completing this lesson, you should be able to do the following: List the operations that use temporary space Create and monitor temporary tablespaces Identify actions that use the temporary tablespace Describe the use of disk and memory for sorting Identify the SQL operations that require sorts Differentiate between disk and memory sorts List ways to reduce total sorts and disk sorts Determine the number of memory sorts performed Set parameters to optimize sorts