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,