Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 Received on Wed Nov 10 1999 - 08:09:25 CST