DOMAIN INDEX

create index buld_nm_idx1 on building_ledg(buld_nm)   indextype is ctxsys.context ;

select * from tn_buld_ledg where contains(buld_nm, '%lott%') >0 ;