Re: Sort tablespace usage

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 16 Jun 2001 18:19:28 -0700
Message-ID: <3B2C05A0.6E5C5BC8@exesolutions.com>

James Williams wrote:

> I have always thought the only space a user has for order by, group,
> etc was from his temp tablespace from the create user. Another tells
> me you can have a specail temp tablespace for sort usage only. Is his
> true? I have not seen such even though its apealing. 8.1.6.3

Sorting should primarily occur in the SORT AREA in memory. If it can not fit there then it is in the TEMP tablespace designated to the user. You can have multiple temp tablespaces and assign different ones to different users.

Daniel A. Morgan Received on Sat Jun 16 2001 - 20:19:28 CDT