Re: Oracle Intermedia Text problem

On 2 Nov 2001 10:32:22 -0800, ikipnis_at_ucg.com (Inna Kipnis) wrote:

>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?

Yuch ... I don't know anything about Intermedia Text ... but can't you search some other way? Is there no subsidiary table with keywords? What does te rest of this table design look like? Received on Sun Nov 04 2001 - 03:48:17 CET