| ctxcat search [message #75922] |
Tue, 12 March 2002 01:35  |
cmn
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
platform:redhat7.2
oracle8.1.7
table: product contains field type,trade_id etc
1.create ctxcat index for product as following
call ctx_ddl.create_index_set('product_iset');
call ctx_ddl.add_index('product_iset','trade_id');
create index product$type on product(type) indextype is ctxsys.ctxcat parameters('index set product_iset');
2.after product$type created
select type from product where catsearch(type,'aa','trade_id=53')>0;
return 18 rows;
but
select type from product where type like '%aa%' and trade_id=53;
return 185 rows;
3.why return different results
thanks!!!
|
|
|
|
| Re: ctxcat search [message #75923 is a reply to message #75922] |
Tue, 12 March 2002 02:00  |
sinan
Messages: 5
Registered: March 2002
|
Junior Member |
|
|
you should create your index with preferences
like
ctx_ddl.create_preference('subs_pre_ind', 'BASIC_WORDLIST');
ctx_ddl.set_attribute('subs_pre_ind','PREFIX_INDEX','YES');
ctx_ddl.set_attribute('subs_pre_ind','PREFIX_MIN_LENGTH',3);
ctx_ddl.set_attribute('subs_pre_ind','PREFIX_MAX_LENGTH', 6);
ctx_ddl.set_attribute('subs_pre_ind','SUBSTRING_INDEX', 'YES');
|
|
|
|
| Re: ctxcat search [message #75925 is a reply to message #75922] |
Tue, 12 March 2002 19:08 |
cmn
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
THANK YOU! BUT
I create index follow your advice as following:
call ctx_ddl.create_index_set('product_iset');
call ctx_ddl.add_index('product_iset','trade_id');
call ctx_ddl.create_preference('subs_pre_ind', 'BASIC_WORDLIST');
call ctx_ddl.set_attribute('subs_pre_ind','PREFIX_INDEX','YES');
call ctx_ddl.set_attribute('subs_pre_ind','PREFIX_MIN_LENGTH',3);
call ctx_ddl.set_attribute('subs_pre_ind','PREFIX_MAX_LENGTH', 6);
call ctx_ddl.set_attribute('subs_pre_ind','SUBSTRING_INDEX', 'YES');
create index product$type on product(type) indextype is ctxsys.ctxcat parameters('wordlist subs_pre_ind index set product_iset');
After long time (about one hour) the index still haven't been created!
I exit by CRTL+C
I don't know if ctxcat index support the preference wordlist!
Some document say wordlist only support Japanese lanuage!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
