Patent ID: 7346612

Claim:
A method for database query optimization in a computer system having a plurality of central processors, comprising the steps of: defining a plurality of logical partitions of said computer system, each logical partition having a respective resource assignment, said resource assignments allocating selective one or more resources of said computer system to said logical partitions, wherein each task executing in said computer system is assigned to a respective one of said logical partitions and restricted to using only the resources of said selective one or more resources which are allocated to the respective logical partition by its respective resource assignment; defining a database query; constructing a first search strategy for said database query, said first search strategy being dependent on a first resource assignment; invoking said database query for execution in a first logical partition, said invoking step being performed after said step of constructing a first search strategy; automatically comparing a second resource assignment to said first resource assignment, said second resource assignment being associated with said first logical partition at the time said invoking said database query for execution step is performed; and automatically constructing a second search strategy dependent on said second resource assignment, said step of automatically constructing a second search strategy being performed dependent on the results of said comparing step; wherein said first resource assignment is the resource assignment for a logical partition with which said database query is associated at the time said step of constructing a first search strategy is performed; and wherein said step of constructing a first search strategy for said database query comprises the step of automatically determining said resource assignment for said logical partition with which said database query is associated at the time said step of constructing a first search strategy is performed.