Searching by Intermedia Text (using CONTAINS)

Hi All,

I am trying to search record by using contains and I gonna to search the
article which contains words 'KEY1', 'KEY2' and 'KEY3'. I using the follows query to perform searching however I found that the speed is very slow.

SELECT TEXT_ID FROM ARTICLE_TABLE WHERE

CONTAINS(Article_Content, 'KEY1', 1) > 0 AND 
CONTAINS(Article_Content, 'KEY2', 3) > 0 AND 
CONTAINS(Article_Content, 'KEY3', 5) > 0

My question is how modify the query so that it could speed up the search and do the same thing as I wanted? Thanks a lot.

Ray Received on Thu Jul 12 2001 - 12:29:29 CEST