Abstract
A relational database management system (RDBMS) executing in a computer system manages a relational database storing column values in columns of a large table and a small table in rows spread across one or more objects. The RBMS also stores metadata comprising summarized information about the column values in the rows and objects of the small table. The RDBMS processes a query that joins the column of the small table to the column of the large table through an equivalence predicate, and derives one or more literal filter conditions for the equivalence predicate from the metadata of the small table. The RDBMS binds the literal filter conditions into the query, and performs a query execution plan for the query with the literal filter conditions, so that only the objects and/or rows in the large table that are qualified by the literal filter conditions are accessed.