I have a table called auction :
Create table auction(item_id varchar2(10), title varchar2(100));
Create table auction(item_id varchar2(10), title varchar2(100));
I create created a context index on the title column :
create index AUCTION_TITLE_CONTEX on auction(title) indextype is ctxsys.context parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
create index AUCTION_TITLE_CONTEX on auction(title) indextype is ctxsys.context parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
I insert inserted some data in the table :
insert into auction values ('1','wilkin');
select score(1), title FROM AUCTION where contains(title,'fuzzy('wilkin',,,weight)',1) >0 order by score(1) desc;
insert into auction values ('1','wilkin'); select score(1), title FROM AUCTION where contains(title,'fuzzy('wilkin',,,weight)',1) >0 order by score(1) desc;
the The result for the score(1) is 48.
You can see that 'wilkin' is an exact match to 'wilkin' .
Why is the score is not 100?
what What can i I do in my index for all exact match matches to give 100 as score?
Thank you?