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

创建

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$%')