demo05.sql

来自「Expert Oracle Database Architecture 9i a」· SQL 代码 · 共 21 行

set autotrace traceonly explain
select owner, object_type
  from t
 where owner between 'T' and 'Z'
   and object_type is not null
 order by owner DESC, object_type DESC;
select owner, object_type
  from t
 where owner between 'T' and 'Z'
   and object_type is not null
 order by owner DESC, object_type ASC;
create index desc_t_idx on t(owner desc,object_type asc);
exec dbms_stats.gather_index_stats( user, 'DESC_T_IDX' );
select owner, object_type
  from t
 where owner between 'T' and 'Z'
   and object_type is not null
 order by owner DESC, object_type ASC;