Recommendation System
You are looking at an older version of the documentation. The latest version is found here.
SYSADMIN.RecommendedOptimizations
This table supplies information on recommended optimizations.
Column Name | Type | Description |
|---|---|---|
| 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 | *** |
SYSADMIN.RecOptSymbols
This table supplies information on symbols (group by symbols, aggregate functions, etc.) associated with a MAT_AGGR optimization.
Column Name | Type | Description |
|---|---|---|
| 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_) |
SYSADMIN.RecommendedIndexes
This table supplies information on recommended indexes.
Column Name | Type | Description |
|---|---|---|
| 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 |
SYSADMIN.MaterializedTable
This table supplies information on materialized tables.
Column Name | Type | Description |
|---|---|---|
| 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 |
We don't have a way to export this macro.