注册

联合主键,where与order by查询,不走索引

🥶🥶🥶 2024/11/27 752 9

DM Database Server 64 v8,创建表CREATE TABLE "A"."B"("C" NUMBER(38,0) NOT NULL,"D" NUMBER(38,0) NOT NULL,"E" NUMBER(38,0),"F" CHAR(24),CONSTRAINT "B_PKEY" NOT CLUSTER PRIMARY KEY("C","D")) STORAGE (ON "BIGTS",CLUSTERBTR).执行SQL语句: SELECT * FROM "A","B" WHERE ((C<=500) or (C=500 AND D< =100000)) ORDER BY "C","D".为什么不走索引,添加hint也无效

回答 0
暂无回答
扫一扫
联系客服