indexing varchar2(200)

[bhooma]

I have a huge table with one of the column name as search_string varchar2(200).

I want to select the columns where instr(search_st ring,'123')>0

I created an index on the column search_string,b ut it doesnt work.

Kindly suggest some faster means to search for a string in the table in the column namely search_string

[rski]

Read that

http://docs.oracle.com/cd/B10501_01/text.920/a96517/cdefault.htm

maybe it will help you

[bhooma]

Thanks alot for the link. Now that i have created an index like this
CREATE INDEX myindex1 ON Table1(search_s tring) INDEXTYPE IS CTXSYS.CTXCAT PARALLEL.

and my qquery is like this
select * from Table1 where catsearch(searc h_string,'%1000 %','')>0
This returns only few rows which has integer field 1000 in any of the columns in the table and doesnt search in the column namely search_string which has long string having eg:ABCDCXXX1000 bgd

whereas instr(search_st ring,'1000')>0 returns thousnads of records.