CREATE TABLE "HUIYING"."T_TEST_HH"
(
"ID" INT IDENTITY(1, 1) NOT NULL,
"NAME" VARCHAR(50),
"ADDRESS" VARCHAR(100),
"SEX" TINYINT,
"ALIAS" VARCHAR(50),
"AGE" INT,
"CREATE_TIME" TIMESTAMP(0),
"COLUMN_1" VARCHAR(255),
"COLUMN_2" VARCHAR(255),
"COLUMN_3" VARCHAR(255),
"COLUMN_4" VARCHAR(255),
"COLUMN_5" VARCHAR(255),
"COLUMN_6" TEXT,
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "MAIN", CLUSTERBTR) ;

CREATE INDEX "index_name_add" ON "HUIYING"."T_TEST_HH"("NAME" ASC,"ADDRESS" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "index_sex_age" ON "HUIYING"."T_TEST_HH"("SEX" ASC,"AGE" ASC,"CREATE_TIME" ASC) STORAGE(ON "MAIN", CLUSTERBTR) ;
CREATE INDEX "index_sex_time" ON "HUIYING"."T_TEST_HH"("SEX" ASC,"CREATE_TIME" DESC) STORAGE(ON "MAIN", CLUSTERBTR) ;
加载400万条数据,使用sex+create_time复合索引
!
用OR子句连接查询很慢，改成in之后查询也很慢