Oracle Intermedia Text problem

From: Inna Kipnis <ikipnis_at_ucg.com>
Date: 2 Nov 2001 10:32:22 -0800
Message-ID: <f7fe21b.0111021032.62b9b82c_at_posting.google.com>

May be somebody can help me with a problem using Intermedia Text search.
The following query returns different results depending on the amount of data in the searched column or the use of wildcards:

SELECT DISTINCT SolNbr

   FROM Notice_Data 
 WHERE  NOTICE_TYPE_ID IN ( 1,2,3,4,7,8, 0 )  AND

(CONTAINS(SUBJ_DESC,'(audio produc%) OR (audio project%) OR (audio
video) OR (audio visual service%) OR (broadcast production) OR
(editing system%) OR (interactive multimedia ) OR (motion picture) OR
(motion video) OR (multi% media) OR (multimedia material%) OR
(multimedia presentation) OR (multimedia service%) OR (multimedia
system%) OR (museum%) OR (near((produc, video%),4)) OR (near((produc, televis%),4)) OR (near((produc, edit%),2)) OR (program edit%) OR
(near((program, televis%),3)) OR (near((program, video%),3)) OR
(program% education%) OR (near((proposal, video),2)) OR (public
service announcement ) OR (publication video) OR (real% time video) OR
(special effect%) OR (near((taping, video%),2)) OR (near((televis,
program%),3)) OR (television broadcast%) OR (television production) OR
(television program%) OR (near((training, video%),2)) OR (near((video,
produc%),3)) OR (near((video, program%),2)) OR (television broadcast%) OR (television production) OR (training tape%) OR (video broadcast%) OR (video documentation) OR (near((video, edit%),1)) OR (video operation%) OR (video
presentation) OR (video program%) OR (video proposal) OR (video publication) OR (video reproduction) OR (video taping) OR (video% service%) OR (videotaped) OR (videotaping) OR (visitor center%) OR
(filming) OR (near((film%, produc%),1))') > 0)

The searched column is CLOB datatype. The table has 10000 records. It was noticed that the query doesn't return some rows that it was supposed to - containing 'video services' which correspond to (video% service%). When the query was modified to look for (video services) - wildcards were removed - it returned those rows. The query would also return those rows with wildcard in place (video% service%), but with amount of rows in the table cut in half (5000 rows).

Is there any kind of limit on the number of ORs in the queries or amount of data to be queried against?
Are there any memory parameters to be set? Received on Fri Nov 02 2001 - 19:32:22 CET