VARCHAR Data Type without Primary Index Example for Optimized Inserts - Teradata Listener

Teradata® Listener™ User Guide

Product
Teradata Listener
Release Number
2.05
Published
March 2019
Language
English (United States)
Last Update
2019-04-25
dita:mapPath
vlj1546974296436.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2910
lifecycle
previous
Product Category
Analytical Ecosystem
CREATE MULTISET TABLE listener.state_information ,FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, DATABLOCKSIZE=1048064 BYTES, CHECKSUM = DEFAULT (
    uuid VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    source_id VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    time_stamp VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    data VARCHAR(512) CHARACTER SET LATIN NOT CASESPECIFIC,
    county VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC,
    state VARCHAR(55) CHARACTER SET LATIN CASESPECIFIC)NO PRIMARY INDEX;