A metadata manager is used in a database management system to collect and maintain
metadata associated with a database. Multiple optimizer instances are permitted
to access the metadata maintained by the metadata manager, often eliminating the
need for individual optimizer instances to retrieve and process metadata directly
from the database. As such, the overhead associated with operations such as collecting,
refining, retrieving and/or maintaining of metadata can be off-loaded from the
optimizer instances, often accelerating individual cost estimation calculations
by optimizer instances, facilitating reuse of metadata calculations and refinements,
and improving metadata consistency between multiple related cost estimates.