SQL - SYSIBM.SYSCOLDISTSTATS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSCOLDISTSTATS
Contains zero or more rows per partition for the first key column of a partitioned index.
Rows are inserted when RUNSTATS scans index partitions of the partitioned index.
No row is inserted if the index is a nonpartitioned index.
Rows in this table can be inserted, updated, and deleted.

Nome da coluna Tipo de dado Descrição Uso
   SMALLINT NOT NULL  Not used  N
 STATSTIME  TIMESTAMP NOT NULL WITH  DEFAULT  If RUNSTATS updated the statistics, the date and time when the last invocation  of RUNSTATS updated the statistics.  G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the basic machine-readable material (MRM) tape.

 N No
 Y Yes		  G
 PARTITION  SMALLINT NOT NULL  Partition number for the table space containing the table in which the column  is defined.  G
 TBOWNER  CHAR(8) NOT NULL  Authorization ID of the owner of the table that contains the column.  G
 TBNAME  VARCHAR(18) NOT NULL  Name of the table that contains the column.  G
 NAME  VARCHAR(18) NOT NULL  Name of the column. If NUMCOLUMNS is greater than 1, this name identifies  the first column name of the set of columns associated with the statistics.  G
 COLVALUE  VARCHAR(254) NOT NULL FOR BIT  DATA  Contains the data of a frequently occurring value. If the value has a
 non-character data type, the data may not be printable.		  S
 TYPE  CHAR(1) NOT NULL WITH
 DEFAULT 'F'		  The type of statistics gathered:

 C Cardinality
 F Frequent Value		  G
 CARDF  FLOAT NOT NULL WITH
 DEFAULT -1		  The number of distinct values for the column group. This number is valid only  for TYPE C statistics.  S
 COLGROUPCOLNO  VARCHAR(254) NOT NULL WITH
 DEFAULT		  Identifies the set of columns associated with the statistics. If the statistics are  only associated with a single column, the field contains a zero length.  Otherwise, the field is an array of SMALLINT column numbers with a  dimension equal to the value in NUMCOLUMNS. This is an updatable column.  S
 NUMCOLUMNS  SMALLINT NOT NULL WITH
 DEFAULT 1		  Identifies the number of columns associated with the statistics.  G
 FREQUENCYF  FLOAT NOT NULL WITH
 DEFAULT -1		  Gives the percentage of rows in the table with the value specified in  COLVALUE when the number is multiplied by 100. For example, a value of 1  indicates 100%. A value of .153 indicates 15.3%.  G

© Copyright IBM Corp.