ZCQ_OVERFLOW_KEYS_INT

ZCQ_OVERFLOW_KEYS_INT stores the identified overflow keys which were not very selective and were associated with a large number of candidates.

Details

  • Schema: FUSION

  • Object owner: ZCQ

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ZCQ_OVERFLOW_KEYS_INT_PK

BATCH_ID, EDQ_KEY

Columns

Name Datatype Length Precision Not-null Comments
BATCH_ID NUMBER 18 Yes Batch ID
EDQ_KEY VARCHAR2 255 Yes EDQ Key
KEYCOUNT NUMBER Yes Count of candidates for a specific key.

Indexes

Index Uniqueness Tablespace Columns
ZCQ_OVERFLOW_KEYS_INT_U1 Unique Default BATCH_ID, EDQ_KEY