18. The apparatus of claim 10 , wherein the affinity value is based on a source of the query.
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.