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...
bhooma
Last Activity: Apr 18 '12, 08:45 PM
Joined: Nov 4 '11
Location:
-
indexing varchar2(200)
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 -
Looks like your csv file has some control char in the end. Open up in textpad and check for hidden characters.Leave a comment:
-
Like clause gave me the same result as Instr. i have 2 indexs on this table ie .ods_acct_id anf report_dt where its been used first in where clause.
can u pls give some some solution by rewriting this queryLeave a comment:
-
bhooma started a topic performance is poor in this query where this table has got millions of recordsin Oracleperformance is poor in this query where this table has got millions of records
query:
SELECT
COUNT(*)
FROM
dwdbo.FNL_DW_CO M_ACCT_D a
WHERE
a.ACCT_REPORT_D T = '30/jun/2011' --v_report_dt
AND
(INSTR(TO_CHAR( a.ods_acct_id), '888') > 0 --v_search_attr
OR INSTR(a.acct_nm , '888') > 0
OR INSTR(a.client_ id, '888') > 0
OR INSTR(a.apace_a cct_nbr,...
No activity results to display
Leave a comment: