Block optimization in the Teradata RDBMS

Abstract

Block optimization involves several techniques used to avoid optimizing blocks or parts of a query separately. This process may involve integrating views, derived tables, and subqueries with the rest of the query. For those query blocks that cannot be integrated with the rest of the query, the Teradata optimizer tries to simplify and optimize these blocks. Such optimizations can be achieved using the satisfiability test (checking if a set of conditions are satisfiable) and generating transitive closure, which allows pushing constraints into and out of query blocks. Several new Block Optimization techniques, added to the new release of Teradata DBMS (V2R5), are described. © Springer-Verlag Berlin Heidelberg 2003.