Methods, apparatuses, and computer program products for materialized query
table matching are provided that include receiving a database query,
retrieving a materialized query table (MQT) from data storage accessible
to a database management system, selecting a join in the materialized
query table between a table that is not invoked by the query and a table
that is invoked in the query, determining whether the selected join is
lossless, and expanding the query to include the lossless join if the
selected join is lossless, expanding the query to include the lossless
join. Determining whether the selected join is lossless may be carried
out by losslessly joining the table that is not invoked by the query to
the query, and determining whether the lossless join to the query matches
the selected join of the materialized query table.