15.10 - ReconfigTableStatsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Optimizer Statistics

DBC

 

View Column

Data Type

Format

Source Table.Column

ReconfigId

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigTableStatsTbl.ReconfigId (Composite UPI)

Phase

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

ReconfigTableStatsTbl.Phase (Composite UPI)

TableId

BYTE(6)

NOT NULL

X(12)

ReconfigTableStatsTbl.TableId

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigTableStatsTbl.DatabaseName (UPI)

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

ReconfigTableStatsTbl.TableName (UPI)

Status

BYTEINT

ZZ9

ReconfigTableStatsTbl.Status

BeginTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigTableStatsTbl.BeginTimeStamp

EndTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ReconfigTableStatsTbl.EndTimeStamp

TotRowCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.TotRowCount

TotByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.TotByteCount

TotCPUSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.TotCPUSecs

TotIOCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.TotIOCount

LowRowCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.LowRowCount

LowRowCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.LowRowCountAmp

HighRowCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.HighRowCount

HighRowCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.HighRowCountAmp

LowByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.LowByteCount

LowByteCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.LowByteCountAmp

HighByteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.HighByteCount

HighByteCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.HighByteCountAmp

LowCPUSecsCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.LowCPUSecsCount

LowCPUSecsCount
Amp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.LowCPUSecsCount
Amp

HighCPUSecsCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.HighCPUSecsCount

HighCPUSecsCount
Amp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.HighCPUSecsCountAmp

LowIOCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.LowIOCount

LowIOCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.LowIOCountAmp

HighIOCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.HighIOCount

HighIOCountAmp

SMALLINT

ZZZZ9

ReconfigTableStatsTbl.HighIOCountAmp

NUSICount

SMALLINT

NOT NULL

ZZZZ9

ReconfigTableStatsTbl.NUSICount

FallBackFlag

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

ReconfigTableStatsTbl.FallBackFlag

DBlockSize

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigTableStatsTbl.DBlockSize

SortFlag

CHAR(1)

NOT NULL

X(1)

ReconfigTableStatsTbl.SortFlag

ActualRedistSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.ActualRedistSecs

ActualDeleteSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.ActualDeleteSecs

EstRedistSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.EstRedistSecs

EstDeleteSecs

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.EstDeleteSecs

FSGIOCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.FSGIOCount

FSysReadCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.FSysReadCount

FSysWriteCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.FSysWriteCount

FSysMiscCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.FSysMiscCount

MsgRcvCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgRcvCount

MsgSendCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgSendCount

MsgMiscCount

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgMiscCount

MsgWaitRcvTime

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgWaitRcvTime

MsgWaitSendTime

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgWaitSendTime

MsgWaitMiscTime

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.MsgWaitMiscTime

NoMemFlushCount

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigTableStatsTbl.NoMemFlushCount

CkptFlushCount

INTEGER

NOT NULL

ZZZZZZZZZ9

ReconfigTableStatsTbl.CkptFlushCount

CheckTableError

Note: This column is not currently used.

FLOAT

NOT NULL

----,---,---,---,--9

ReconfigTableStatsTbl.Count1

This view provides the end user a way to access the ReconfigTableStatsTbl. Users with the appropriate privileges can SELECT or DELETE from the base table via the view. Note that only SELECT and/or DELETE privileges should be granted to users by user DBC.

DBlockSize

The default value for DBlockSize is zero.

Possible Values for FallBackFlag

 

Value

Description

Y

Fallback table (default)

N

Non-fallback table

Possible Values for Phase

 

Value

Description

R

Redistribution phase

D

Deletion/rebuild NUSI phase

Possible Values for Status

 

Value

Description

0

Not completed

1

Completed

2

Retry