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