Well, I have no idea what the name of the index is, but supposing you had an index named index1 on table1.col1, then
SELECT /*+ INDEX(T1,INDEX1) */ * FROM TABLE1 T1 WHERE COL1 LIKE '%PROD%'

HTH,

- Chris

[Edited by chrisrlong on 07-27-2001 at 10:01 AM]