OraFAQ Forum: Text & interMedia » Refresh of indexes on CLOB fields.

Home » Server Options » Text & interMedia » Refresh of indexes on CLOB fields. (Oracle,10.2.0.4.0,linux red hat 4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Refresh of indexes on CLOB fields. [message #355050]

Wed, 22 October 2008 06:54

Malakay79
Messages: 41
Registered: September 2007

Member

I have 1 index on a clob column create in this way:

CREATE INDEX index_name
ON TABELLA (COLONNA)
INDEXTYPE IS ctxsys.context
PARAMETERS ( 'STOPLIST mystop' );

This fild is updated very often.
I have created a job that refresh that index with ctx_ddl.sync_index

There is another way to schedule his refresh?

IF I use a trigger after insert or update I think this can be too heavy because sometimes there are 200 people that modify that table in that column.

Thanks

Report message to a moderator

[Message index]

		Refresh of indexes on CLOB fields. By: Malakay79 on Wed, 22 October 2008 06:54
		Re: Refresh of indexes on CLOB fields. By: Barbara Boehmer on Wed, 22 October 2008 11:52
		Re: Refresh of indexes on CLOB fields. By: Malakay79 on Wed, 22 October 2008 12:58
		Re: Refresh of indexes on CLOB fields. By: Barbara Boehmer on Wed, 22 October 2008 15:49

Previous Topic:	Query expansion and FIRST_ROWS problem
Next Topic:	Problems with CTX_DOC.SNIPPET on HTML documents

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:52:13 CDT 2024