This content has been marked as final. Show 2 replies
That's correct. "be" is a stopword, as are "a", "the", "am", "is" etc.
See the list here:
These words are not indexed by default as they are considered "noise" words which are not useful for searching but take up a lot of space in the index.
If you want to index all words, you can create your own empty stoplist, or use "ctxsys.empty_stoplist"
drop table table4; create table table4(id number, text varchar2(4000)); insert into table4 values(1,'Ab Be'); insert into table4 values(2,'Ab Cd'); commit; create index index1 on table4(text) indextype is ctxsys.ctxrule parameters ('stoplist ctxsys.empty_stoplist'); select * from dr$index1$I; select * from table4 where matches (text, 'ab be') > 0; select * from table4 where matches (text, 'ab') > 0;