SYSADMIN.RecommendedOptimizations

このテーブルは、推奨される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

SYSADMIN.RecOptSymbols

このテーブルは、MAT_AGGR最適化に関連するシンボル(シンボルによるグループ化、集約関数など)に関する情報を提供します。

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_)

SYSADMIN.RecommendedIndexes

このテーブルは、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

SYSADMIN.MaterializedTable

このテーブルは、マテリアライズド・テーブルに関する情報を提供します。

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