oracle 8i ConText problem

hi all,

   I've installed Oracle 8i with InterMedia text feature(formerly called ConText) on NT box. I have a 300,000 records table. I'd like to search text in this table by using this text-indexs feature. now it works. but it is slower than table scan.

I created the index by

CREATE INDEX IDX_SEARCH_KEYWORD ON my_table(KEYWORD) indextype is ctxsys.context parameters('lexer my_lexer');

when I issued following statement

select * from my_table where contains(KEYWORD,'JACK')>0;

it takes several minutes to respones. I think I have overlooked something. any idea?

thanks in advance.

daning

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 10 1999 - 14:49:49 CST