Understanding DB2®: Learning Visually with Examples

M

maintenance window

A user-defined time period for running only required automatic maintenance activities.

mass delete

The deletion of all rows in a table.

massively parallel processing (MPP)

The coordinated execution of a single request either by multiple single-processor computers in a shared-nothing environment (in which each computer has its own memory and disks) or by symmetric multiprocessor (SMP) computers (in which multiple processors in each computer share memory and disks). Both environments require that all computers are linked together in a high-speed network.

materialized query table

A table whose definition is based on the result of a query and whose data is in the form of precomputed results taken from the one or more tables that ...