暂无图片
返回数说广场
H
2024-03-06
普通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
分享

评论

热门数说