Home » Server Options » Text & interMedia » ctxcat search
ctxcat search [message #75922] Tue, 12 March 2002 01:35 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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!
Previous Topic: Re: ORACLE definition
Next Topic: Re: array(Urgent)
Goto Forum:
  


Current Time: Wed Apr 16 07:06:04 CDT 2014

Total time taken to generate the page: 0.11500 seconds