Re: Several Contains join by AND OR

Are your indexes "indextype is ctxsys.ctxcat"? I have not used text searching before, but these seem to be a prerequisite.

Good Luck!

EA

iqboss_at_hotmail.com (Ricky) wrote in message news:<a9c648ec.0212091028.51dde5fc_at_posting.google.com>...
> I am trying to search record by using contains and I made 3 intermedia
> text indexes for the column "relation", "en1", "en2". However I found
> that the speed is very slow when I try to use all 3 indexes join by
> "AND" "OR". Although the table is a big table having 7 million entries
> but the searching time should not be like 10+ min for returning 4000
> items.
>
> SELECT * FROM en_table WHERE
> (CONTAINS(relation, 'KEY1', 1) > 0 )AND
> (CONTAINS(en1, 'KEY2', 2) > 0 OR CONTAINS(en2, 'KEY2', 3) > 0
>
>
> My question is how to modify the query so that it could speed up the
> search and do the same thing as I wanted? Thanks a lot. I tried every
> possible way i could think of to optimize the index(analyze,changing
> buffer size) but still yielding the same slow performance. PLEASE
> HELP.
>
> Thank you in advance,
>
> Wei
Received on Wed Dec 11 2002 - 15:49:49 CET