SYSCAT.AIOPT_TABLECARDMODELS catalog view
Each row represents a model for cardinality estimation within the optimizer for local predicates associated with a table.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| MODELSCHEMA | VARCHAR (128) | Schema name of the model. | |
| MODELNAME | VARCHAR (128) | Model name. | |
| VERSION | SMALLINT | Model Version (current version being used is 0). | |
| TRAIN_STATE | CHAR (1) | Training status for the model. | |
| VALID | CHAR (1) | Validity of the model. | |
| CREATE_TIME | TIMESTAMP | Time when the model was created. | |
| MODIFY_TIME | TIMESTAMP | Time when the model was modified . | |
| TABSCHEMA | VARCHAR (128) | Associated base table schema. | |
| TABNAME | VARCHAR (128) | Associated base table name. | |
| TABCOLUMNS | VARCHAR (4000) | List of columns associated with the model. | |
| ISENABLED | CHAR (1) | Flag indicating whether a column is used. |