You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/11/12 17:21:11 UTC
[jira] [Commented] (TRAFODION-1618) Row count estimation method
used in Update stats can be improved
[ https://issues.apache.org/jira/browse/TRAFODION-1618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15002335#comment-15002335 ]
Suresh Subbiah commented on TRAFODION-1618:
-------------------------------------------
DDL for table where problem was seen. If necessary we can use fake data to reproduce the problem
>>showddl bseg;
CREATE TABLE TRAFODION.NEWTEST.BSEG
(
MANDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUKRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BELNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, GJAHR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, BUZID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGCP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGBL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BSCHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOART VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UMSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UMSKS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZUMSK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SHKZG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GSBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PARGB VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MWSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QSSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, KZBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSWBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSWSL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXBHW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TXBFW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSTS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WMWST NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWBAS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FWBAS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWZUZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FWZUZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SHZUZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STEKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MWART VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KTOSL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QSSHB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, KURSR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, GBETR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, VALUT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZUONR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SGTXT VARCHAR(200 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZINKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBUND VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BEWAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ALTKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VORGN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDLEV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FDWBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FDTAG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FKONT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOKRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KOSTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PROJN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUFNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBELN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBEL2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, POSN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ETEN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANLN1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANLN2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANBWA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BZDAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PERNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XUMSW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XHRES VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XKRES VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XOPVW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XCPDD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSKST VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSAUF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSPRO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSERG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XFAKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XUMAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XANET VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XSKRL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XINVE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XPANZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XAUTO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XNCOP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XZAHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SAKNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HKONT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KUNNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LIFNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FILKD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XBILK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GVTYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HZUON VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZFBDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZTERM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZBD1T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD2T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD3T NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD1P NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZBD2P NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKFBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNTO NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WSKTO NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ZLSCH VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZLSPR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZBFIX VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HBKID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BVTYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NEBTR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWSK3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, WRBT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, REBZG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REBZT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZOLLT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZOLLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LZBKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LANDL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DIEKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SAMNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ABPER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VRSKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VRSDT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DISBZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, WVERW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFBU VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ANFAE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BLNBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BLNKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BLNPZ NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MSCHL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MANSP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MADAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MANST VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MABER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRRE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ESRPZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KLIBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, QSZNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, QBSHB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, QSFBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVHW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVFW NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MATNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, WERKS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MENGE NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MEINS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ERFMG NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, ERFME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BPMNG NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BPRME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EBELN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EBELP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZEKKN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ELIKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VPRSV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEINH NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BWKEY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BWTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BUSTW VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, REWRT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, REWWR NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BONFB NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BUALT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PSALT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NPREI NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TBTKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STCEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGBLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGLLD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RSTGR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RYACQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RPACQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, RDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PRCTR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XHKOM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VNAME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RECID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EGRUP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VPTNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VERTT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VERTN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, VBEWA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DEPOT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXJCD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, IMKEY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DABRZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, POPTS NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FIPOS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KSTRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, NPLNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUFPL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, APLZL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PROJK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' NOT NULL NOT DROPPABLE SERIALIZED
, PAOBJNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PASUBNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SPGRC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BTYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ETYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XEGDR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LNRAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HRKFT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DMBE2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMBE3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB21 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB22 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB23 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB31 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB32 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, DMB33 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWST2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, MWST3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVH2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, NAVH3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNT2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, SKNT3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, RDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, HWMET VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GLUPM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XRAGL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, UZAWE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LOKKT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FISTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GEBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STBUK VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXBH2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, TXBH3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPRCT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KBLNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KBLPOS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, STTAX NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, OBZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XNEGP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, RFZEI VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, CCBTC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, EMPFB VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XREF3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS2 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS3 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DTWS4 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRICD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRIRG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GITYP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XPYPR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KIDNO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ABSBT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, IDXSP VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LINFV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KONTT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KONTL VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TXDAT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AGZEI NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PYCUR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PYAMT NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, BUPLA VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SECCO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, LSTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, CESSION_KZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRZNR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PPDIFF NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPDIF2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PPDIF3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC1 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC2 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENLC3 NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENFC NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, PENDAYS NUMERIC(20, 0) DEFAULT NULL NOT SERIALIZED
, PENRC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GRANT_NBR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SCTAX NUMERIC(20, 3) DEFAULT NULL NOT SERIALIZED
, FKBER_LONG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, GMVKZ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SRTYPE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, INTRENO VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MEASURE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, AUGGJ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PPA_EX_IND VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, DOCLN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, SEGMENT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PSEGMENT VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PFKBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, HKTID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, KSTAR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XLGCLR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, TAXPS VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PAYS_PROV VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PAYS_TRAN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, MNDID VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, XFRGE_BSEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZGLLX VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZHZFC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCGJG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZPAY_TY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZBUS_TY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCUS1 VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZWLXQ VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZTAX_LIFN VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZYIJIF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZICTBM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZCP_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZKH_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZWY_ABC VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZZGLSBM VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PGEBER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PGRANT_NBR VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, BUDGET_PD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PBUDGET_PD VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEROP_BEG VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PEROP_END VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, FASTPAY VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, IGNR_IVREF VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRODPER VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZDATE VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, ZTIME VARCHAR(50 CHARS) CHARACTER SET UTF8
COLLATE DEFAULT DEFAULT _UTF8'' SERIALIZED
, PRIMARY KEY (GJAHR ASC, BUZEI ASC, BELNR ASC, BUKRS ASC, PROJK ASC, MANDT
ASC)
)
SALT USING 72 PARTITIONS
ON (BELNR)
HBASE_OPTIONS
(
DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'SNAPPY',
MEMSTORE_FLUSH_SIZE = '1073741824'
)
;
--- SQL operation complete.
>>exit;
End of MXCI Session
> Row count estimation method used in Update stats can be improved
> ----------------------------------------------------------------
>
> Key: TRAFODION-1618
> URL: https://issues.apache.org/jira/browse/TRAFODION-1618
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Reporter: Qifan Chen
>
> For a customer table, the row count is estimated as 2343750004, while the actual row account is 25055150.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)