Recommendation System

This table supplies information on recommended optimizations.

Column Name	Type	Description
`Id`	biginteger	Optimization ID
`Type`	string	Materialization type of this optimization
`MatchDescriptor`	string	Match descriptor
`Freq`	biginteger	Frequency of this optimization
`Enabled`	boolean	Flag to signal if the optimization is enabled or not
`matTablePrefix`	string	Prefix used for the set of materialized tables associated with this optimization
`sourceState`	string	State of the source tables
`sourceStateComment`	string	Reason why the source state is `NOT_AVAILABLE`. If the state is OK, the value of this field should be null
`dwhState`	string	State of the analytical storage schema
`dwhStateComment`	string	Reason why the analytical storage state is `NOT_AVAILABLE`. If the state is OK, the value of this field should be null
`lastReplicationState`	string	State of the last replication task
`lastReplicationStateComment`	string	Reason why the last replication execution failed. If the state is OK, the value of this field should be null
`nextSelectState`	string	Possible state of the next select query execution
`nextReplicationState`	string	Possible state of the next replicator execution
`lastUsed`	timestamp	Timestamp when the corresponding query was last executed
`lastMaterialized`	timestamp	Timestamp when the optimization was last materialized
`allowIndexCreationByType`	string	***
`allowIndexCreationByStatus`	string	***
`uuid`	string	Optimization UUID

uuid column in SYSADMIN.RecommendedOptimizations is available since v4.1

This table supplies information on symbols (group by symbols, aggregate functions, etc.) associated with a MAT_AGGR optimization.

Column Name	Type	Description
`ID`	biginteger	Symbol ID
`recOptID`	biginteger	ID of the associated optimization
`symbol`	string	Actual symbol or expression (e.g. `SUM(views.v1.a)`)
`type`	string	Optimization symbol type (e.g. `AGGR`, `GROUP_BY`)
`aggrFunction`	string	Aggregation function (e.g. `SUM`). Can be null
`alias`	string	Alias of the symbol used in the materialized table (e.g. `sum_views_v1_a_`)

This table supplies information on recommended indexes.

Column Name	Type	Description
`id`	biginteger	Index ID
`columnName`	string	Column name
`type`	string	Index type (e.g. `JOIN`, `WHERE`, etc.)
`kind`	string	***
`freq`	biginteger	***
`status`	string	***
`recOptID`	biginteger	ID of the associated optimization
`parentRecOptID`	biginteger	ID of the parent optimization (in case of `JOIN` type). Can be null

This table supplies information on materialized tables.

Column Name	Type	Description
`ID`	biginteger	ID of the materialized table
`recOptID`	biginteger	ID of the associated recommended optimization
`name`	string	Materialized table name
`type`	string	Materialization type (e.g. `MAT_TABLE`, `MAT_JOIN`, `MAT_AGGR`)
`accessState`	string	State of the materialized table during the replication process (e.g. `READY`, `UPDATING`, `INCOMPLETE`, etc.)
`creationTime`	timestamp	Timestamp when the materialized table was created
`lastModified`	timestamp	Timestamp when the materialized table was last modified