SQL predicate migration

摘要

A method of rewriting a Structured Query Language (SQL) statement in order to prevent processing of a join between a master table and a detail table in a database is described. The method comprises determining in the SQL statement a unique identifier to a row of the master table. The unique identifier is then equated to an identifier to related rows of the detail table using the join condition. A revised SQL statement is then produced that only refers to the detail table using the identifier to the rows of the detail table. The revised SQL statement is then processed.