为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM Database Server 64 V8 DB Version: 0x7000c
【操作系统】:WINDOW
【CPU】:X86
【问题描述】*:
drop table if exists t1 ;
CREATE TABLE "T1"
(
"A" VARCHAR(8) NOT NULL,
"B" VARCHAR(8) NOT NULL,
NOT CLUSTER PRIMARY KEY("A", "B")) STORAGE(ON "MAIN", CLUSTERBTR) ;
insert into T1 values('1','1');
insert into T1 values('2','2');
insert into T1 values('3','3');
commit;
运行下面两个展示不一样
select top 0,101 * from ( select distinct a from "TEST"."T1" order by a desc);
select distinct a from "TEST"."T1" order by a desc;
有点东西
测试加上 /+DISTINCT_USE_INDEX_SKIP(0)/
加上/*+ OPTIMIZER_MODE(1) /试试
select /+ OPTIMIZER_MODE(1) */ distinct a from "TEST"."T1" order by a desc;