Show Materialized query table

To show materialized query tables associated with a table:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Table container object.
  5. Right-click a table and select Show MQT.

For details about the columns displayed, see Columns for show indexes.