Patent 7702627 was granted and assigned to Oracle on April, 2010 by the United States Patent and Trademark Office.
During query optimization, when a particular type of transformation is considered, the effect of performing one or more subsequent kinds of transformations is also considered in conjunction with the first. When applying a transformation, which forecloses applying another, both are considered independently.