Re: Oracle text search is slow. Need help
Date: Mon, 18 Feb 2008 20:42:08 +0100
> We have oracle 10g r2 running on RHEL4 iwth 4g ram
> We are using oracle text indexing feature to index LOB columns.
> But the query is taking more than a minute. Can someone please help me
> on this.
> Here is the code
> select * from arc_44 where FILE_DATE >= to_date('01/01/2001','dd-mm-
> yyyy') and FILE_DATE <= to_date('15/12/2001', 'dd-mm-yyyy') and
> ( contains(FULL_TEXT,'malaysia' ) > 0 or
> contains(CONTENT,'malaysia' ) > 0 or upper(META_DATA) LIKE
> upper('%malaysia%') ) ;
> Here FULL_TEXT and CONTENT are CLOB datatypes.
> Thanks in advance
How slow is
select * from arc_44 where
FILE_DATE >= to_date('01/01/2001', 'dd-mm-yyyy') and FILE_DATE <= to_date('15/12/2001', 'dd-mm-yyyy')
Why two/three indexes ( on FULL_TEXT, CONTENT and META_DATA),
if one is sufficient?
Some time ago (2 weeks?) there was a thread on combining text index fields (CLOBs) into one index.
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Mon Feb 18 2008 - 13:42:08 CST