oracle 反向索引

create index I_INFO_CLASSID on b_info(CLASSID);
create index I_INFO_CLASSID_REVERSE on b_info(reverse(CLASSID));
analyze table b_info compute statistics for table for all indexes;
–都使用索引
select * from b_info where classid like ‘1E92C5409E99484%’;
–都使用索引
select * from b_info where reverse(classid) like reverse(‘%33B27’);

标签