Index on multivalue varchar2 field

[jacklainer]

Hello,

I have a table with more than 10 million records in. There's one varchar2 attribute holding comma delimited values. so one column could look like: "ED57667,868D866,R4124141,JH231311"

What are the options to make queries for this attribute fast? If I do a search "like %R4124141%" the query is very slow. What kind of index should I use?

thanks for your help

marco

[debasisdas]

Try creating a simple b-tree index.