The ANALYZE statement provides the following information about the specified databases:
- Time and date the archive operation occurred.
- Whether the archive is of all AMPs, clusters of AMPs, or specific AMPs.
- The name of each database, the name of each object in each database, and the fallback status of the tables (if the LONG option is specified).
- The number of bytes and rows in each table (if the LONG or VALIDATE option is specified).
- If an archive file contains a selected partition archive of a table, the bounding condition used to select the archived partitions is displayed with an indication as to whether the bounding condition is well-defined.
- Online logging information.
- User-Defined Method (UDM) and User-Defined Type (UDT) information.
- If the archive file contains Stat Collection DDL, the DDL can be displayed by specifying the DISPLAY LONG option.
The DISPLAY and VALIDATE options can both be specified in a single ANALYZE statement. The default is DISPLAY.