altibase icon indicating copy to clipboard operation
altibase copied to clipboard

Performance Test - Schema

Open Lee-Sangmin-70 opened this issue 4 years ago • 1 comments

$cat schema.sql

DROP TABLE TEST;

CREATE TABLE TEST ( K01 INTEGER, K02 INTEGER, K03 INTEGER, K04 INTEGER, K05 INTEGER, K06 INTEGER, K07 INTEGER, K08 INTEGER, K09 INTEGER, K10 INTEGER, K11 INTEGER, K12 INTEGER, K13 INTEGER, K14 INTEGER, K15 INTEGER, K16 INTEGER, K17 INTEGER, K18 INTEGER, K19 INTEGER, K20 INTEGER, K21 INTEGER, K22 INTEGER, K23 INTEGER, K24 INTEGER, K25 INTEGER, K26 INTEGER, K27 INTEGER, K28 INTEGER, K29 INTEGER, K30 INTEGER, K31 INTEGER, K32 INTEGER, K33 INTEGER, K34 INTEGER, K35 INTEGER, K36 INTEGER, K37 INTEGER, K38 INTEGER, K39 INTEGER, K40 INTEGER, K41 INTEGER, K42 INTEGER, K43 INTEGER, K44 INTEGER, K45 INTEGER, K46 VARCHAR(30), K47 VARCHAR(30), K48 VARCHAR(30), K49 VARCHAR(30), K50 VARCHAR(30) );

ALTER TABLE TEST ADD CONSTRAINT TEST_INDEX PRIMARY KEY ( K01 );

Lee-Sangmin-70 avatar Sep 27 '21 14:09 Lee-Sangmin-70

schema.sql

Lee-Sangmin-70 avatar Sep 27 '21 14:09 Lee-Sangmin-70