Abstract: A resource allocation system for a database environment. In a specific embodiment, the resource allocation system is adapted to implement a method that includes receiving a first signal from a user input device to identify a SQL SELECT statement to be used in a future database query. The system receives a second signal from the user input device to determine a resource to be used when the SELECT statement is executed. The system then stores, in a storage device, an indication of the resource in association with the SELECT statement so that when the SELECT statement is executed the resource is used.

Abstract: A method, computer-readable medium, and machine are provided for boosting the performance of sort operations. A database server performs an operation on a set of data. The operation uses disk space such as a temporary tablespace. The disk space belongs to a disk group in which data is stored according to a level of redundancy. A determination is made as to whether the operation is a sort operation. If the operation is not a sort operation, then at least part of a result of the operation is stored on the disk space according to the level of redundancy specified for the disk group. If the operation is a sort operation, then only a single copy of the at least part of the result is stored without storing a redundant copy of the at least part of the result. Optionally, backup information sufficient to re-perform the sort operation may also be stored.

Abstract: A resource allocation system for a database environment. In a specific embodiment, the resource allocation system is adapted to implement a method that includes receiving a first signal from a user input device to identify a SQL SELECT statement to be used in a future database query. The system receives a second signal from the user input device to determine a resource to be used when the SELECT statement is executed. The system then stores, in a storage device, an indication of the resource in association with the SELECT statement so that when the SELECT statement is executed the resource is used.

Abstract: A method, computer-readable medium, and machine are provided for boosting the performance of sort operations. A database server performs an operation on a set of data. The operation uses disk space such as a temporary tablespace. The disk space belongs to a disk group in which data is stored according to a level of redundancy. A determination is made as to whether the operation is a sort operation. If the operation is not a sort operation, then at least part of a result of the operation is stored on the disk space according to the level of redundancy specified for the disk group. If the operation is a sort operation, then only a single copy of the at least part of the result is stored without storing a redundant copy of the at least part of the result. Optionally, backup information sufficient to re-perform the sort operation may also be stored.