4. The method of claim 3 , further comprising: if the first query plan that implements the first query is not found in the expected affinity and is not found in the unexpected affinity, determining a candidate affinity for the first query and initializing a candidate affinity hit count and a candidate affinity total count to zero.
4. The method of claim 3 , further comprising: if the first query plan that implements the first query is not found in the expected affinity and is not found in the unexpected affinity, determining a candidate affinity for the first query and initializing a candidate affinity hit count and a candidate affinity total count to zero. 5. The method of claim 4 , further comprising: if the first query plan that implements the first query is found in the unexpected affinity and the unexpected affinity equals the candidate affinity, incrementing the candidate affinity hit count and incrementing the candidate total count for the first query; and if the first query plan that implements the first query is found in the unexpected affinity and the unexpected affinity does not equal the candidate affinity, incrementing the candidate total count for the first query but not incrementing the candidate affinity hit count for the first query.