Displaying materialized query table columns
You can display materialized query tables associated with another table using System i® Navigator.
To display materialized query tables, follow these steps:
- In the System i Navigator window, expand the system that you want to use.
- Expand Databases and the database that you want to work with.
- Expand Schemas and the schema that you want to work with.
- Right-click a table and select Show Materialized Query Tables.
Column name | Description |
---|---|
Name | The SQL name for the materialized query table |
Schema | Schema or library containing the materialized query table |
Partition | Partition detail for the index. Possible values:
|
Owner | The user ID of the owner of the materialized query table. |
System Name | System table name for the materialized query table |
Enabled | Whether the materialized query table is enabled.
Possible values are:
|
Creation Date | The timestamp of when the materialized table was created. |
Last Refresh Date | The timestamp of the last time the materialized query table was refreshed. |
Last Query Use | The timestamp when the materialized query table was last used by the optimizer to replace user specified tables in a query. |
Last Query Statistics Use | The timestamp when the materialized query table was last used by the statistics manager to determine an access method. |
Query Use Count | The number of instances the materialized query table was used by the optimizer to replace user specified tables in a query. |
Query Statistics Use Count | The number of instances the materialized query table was used by the statistics manager to determine an access method. |
Last Used Date | The timestamp when the materialized query table was last used. |
Days Used Count | The number of days the materialized query table has been used. |
Date Reset Days Used Count | The year and date when the days-used count was last set to 0. |
Current Number of Rows | The total number of rows included in this materialized query table at this time. |
Current Size | The current size of the materialized query table. |
Last Changed | The timestamp when the materialized query table was last changed. |
Maintenance | The maintenance for the materialized query table.
Possible values are:
|
Initial Data | Whether the initial data was inserted immediately
or deferred. Possible values are
|
Refresh Mode | The refresh mode for the materialized query table. A materialized query table can be refreshed whenever a change is made to the table or deferred to a later time. |
Isolation Level | The isolation level for the materialized query table. |
Sort Sequence | The alternate character sorting sequence for National Language Support (NLS). |
Language Identifier | The language code for the object. |
SQL Statement | The SQL statement that is used to populate the table. |
Text | The text description of the materialized query table. |
Table | Schema and table name. |
Table Partition | Table partition. |
Table System Name | System name of the table. |