--创建测试表和索引drop table t purge;create table t as select * from dba_objects;create index idx_object_id on t(object_id);--全表扫描TABLE ACCESS FULLselect count(*) from t;--索引扫描INDEX FAST FULL SCAN,加上非空判断之后,就会
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号