返回数说广场
0
普通X86服务器,Oracle数据库19C版本,非In-Memory Option,创建如下表格,并插入数据:
create table test as select * from dba_objects;
insert into test select * from dba_objects;
insert into test select * from dba_objects;
commit;
以下哪种索引创建方式以及后面的查询语句,可以使执行计划走"INDEX FAST FULL SCAN" ?(不要考虑其它复杂情况,多选题)
A
create index idx2_test on test(object_id,0); select count(*) from test;
C
create index idx2_test on test(object_id,0); select count(*) from test where object_id is not null;
D
create index idx1_test on test(object_id); select count(*) from test where object_id is not null;
E
create index idx2_test on test(object_id,0); select count(object_id) from test where object_id is null;
0
0 165
分享
评论
热门数说


