>> oracle still use full scan with table when using LIKE '%dfs%' Yeah, the tip never said that it would index with TWO wildcards, one on each end . . .
However, the reverse index should work if you reverse the key too
If you had '%dfs' . . .
You could use a reverse index if you did 'sfd%' . . .
One obscure trick for indexing queries with a leading wildcard character (like '%SON') is to create a REVERSE index and them programmatically reverse the SQL like clause to read "like 'NOS%'", effectively indexing on the other side of the text, clumsy, yet effective.
I'm going to have a consultant look into this, thanks for the note . . .