10. A highly parallel computing apparatus for an enterprise data warehouse system or a business intelligence system, the apparatus comprising: a plurality of processors in the highly parallel computing apparatus; memory resources in the highly parallel computing apparatus; a database server configured to receive a database query from an application at a database client system; a query compiler configured to prepare an execution plan for the query and compute a number of executive server processes (ESPs) in each ESP layer of the query; a workload management system configured to generate an affinity value based on the current run-time state of the apparatus, wherein the affinity value specifies a subset of processors for a range of processor subset sizes; and a query executor configured to execute the query wherein placement of ESP layers of the query onto processors of the computing system is determined using the affinity value.
16. The apparatus of claim 10 , wherein the affinity value is based on a current run-time state of the apparatus.