About avoiding Fuzzy Query index aging problem

When Waybill_no exists index

SELECT *
From Ucmp_waybill_rec_mem R
where R.createtm >= trunc (sysdate-1)
and R.type = ' 2 '
and r.waybill_no like ' 33% '

And

SELECT *
From Ucmp_waybill_rec_mem R
where To_char (R.createtm) > ' 2016-01-29 '
and R.type = ' 2 '
and substr (r.waybill_no,1,3) = ' 033 '

When the data is 100 million, the first 1.5 hours is not yet investigated, the second 4 minutes to resolve,

I know the index will fail, but not the first time to try to avoid, leading to delay time, remember

When the index fails, try to avoid it, and there are ways to avoid

About avoiding Fuzzy Query index aging problem