Show Materialized query table
To show materialized query tables associated with a table:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Click the Table container object.
- Right-click a table and select Show MQT.
For details about the columns displayed, see Columns for show indexes.