Users can specify their own temporary tablespaces, Alter User XXX Temporary TableSpace XXX when creating users and modify users
Temporary table space can be sorted or summarized by ORDER BY
