Ansicht
Dokumentation

RSINF027 - INFORMIX Data Distribution Table (sysdistrib)

General Data in Customer Master   General Material Data  
Diese Dokumentation steht unter dem Copyright der SAP AG.

Beschreibung

INFORMIX System Monitoring Interface Tables

sysdistrib (Data Distribution Information)

Column Type Description

tabid INTEGER Table identifier of the table where data
was gathered

colno SMALLINT Column number in the source table

seqno INTEGER Sequence number for multiple entries

constructed DATE Date when the data distribution was
created

mode CHAR(1) Optimization level:
L = Low
M = Medium
H = High

resolution FLOAT Specified in the update statistics
statement

confidence FLOAT Specified in the update statistics
statement

encdat CHAR(256) ASCII encoded histogram in fixed-length
character field; accessible only to user
informix.

Voraussetzungen

Ausgabe

Beispiel

PERFORM Short Reference   CPI1466 during Backup  
Diese Dokumentation steht unter dem Copyright der SAP AG.

Length: 1413 Date: 20240520 Time: 060556     sap01-206 ( 16 ms )