One method I've tried that seems to be a bit faster is to do this:
Of course, you could create a ConText index:
WHERE INSTR( addr_line1, 'FIRST AVE' ) <> 0;
Then you could execute a query like this:
CREATE INDEX emp_resume_idx
ON emp(resume) INDEXTYPE IS ctxsys.context;
The only problem witha ConText index is that you have rebuild it as often as you update/insert data to keep it completely up to date.
WHERE CONTAINS (resume, 'DBA') > 0;
Hope this helps!
save disk space, use smaller fonts