建立 reverse index :

create table objects
as
select * from dba_objects;

create index obj_idx on objects(OBJECT_NAME) reverse;

create index obj_idx_reverse on objects(reverse(OBJECT_NAME));

reverse index使用：

select * from objects

where reverse(object_name) LIKE reverse('%OL$')

或

select * from objects

where reverse(object_name) LIKE ('OL$%')

Oracle 反向索引 where index_column like '%xxx'

相關文章