1. A method executing on a processing system, wherein the processing system is coupled to a user input device and a storage device storing a database, the method comprising: determining, using the processing system, whether data specifying information meets a first criterion or a second criterion, with the data specifying information included in a WHERE clause of a SELECT statement, with the data specifying information specifying data in the database that is the subject of the SELECT statement; triggering, using the processing system, a first resource group specification if the information included in the WHERE clause meets the first criterion, where the first resource group specification allocates a first set of processing resources of the processing system; triggering, using the processing system, a second resource group specification if the information included in the WHERE clause meets the second criterion, where the second resource group specification allocates a second set of processing resources of the processing system; and processing, using the processing system, the SELECT statement using either the first set of processing resources or the second set of processing resources based on which resource group specification is triggered.
1. A method executing on a processing system, wherein the processing system is coupled to a user input device and a storage device storing a database, the method comprising: determining, using the processing system, whether data specifying information meets a first criterion or a second criterion, with the data specifying information included in a WHERE clause of a SELECT statement, with the data specifying information specifying data in the database that is the subject of the SELECT statement; triggering, using the processing system, a first resource group specification if the information included in the WHERE clause meets the first criterion, where the first resource group specification allocates a first set of processing resources of the processing system; triggering, using the processing system, a second resource group specification if the information included in the WHERE clause meets the second criterion, where the second resource group specification allocates a second set of processing resources of the processing system; and processing, using the processing system, the SELECT statement using either the first set of processing resources or the second set of processing resources based on which resource group specification is triggered. 7. The method of claim 1 wherein the processing resources further include CPU processing time in an intelligent storage sub-system.