3. The method according to claim 2 , wherein the rewriting step comprises the step of: rewriting the criteria to reference the first field and a third field from the first table, wherein a first search condition in the query searches on a match between the first field and the second field, and a second search condition in the query searches on a match between the second field and the third field, and wherein applying transitive closure analysis includes determining that the third field is equivalent to the second field in the criteria.
2. The method according to claim 1 , further comprising the step of: determining if the criteria references a first field from a first table and a second field from a second table.