Home » Server Options » Text & interMedia » Updating index information without recreating the index AND Problem executing ctx procedures (merged
icon4.gif  Updating index information without recreating the index AND Problem executing ctx procedures (merged [message #270431] Wed, 26 September 2007 21:34 Go to previous message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
Hi. I have this base table that has an index. And I perform different operation on the base table like inserting, updating and deleting. This is my index structure, with substring_index and prefix_index set to true:

create index idx_my_index on my_table(my_colum)
indextype is ctxsys.context
parameters('LEXER my_lexer WORDLIST my_word_list
STORAGE my_storage STOPLIST my_stop_list
SYNC (ON COMMIT) TRANSACTIONAL');

When inserting there is no problem, but how can I (any ideas) update the data of the $i and $p tables when I update or delete without recreating the index..??
 
Read Message icon4.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Disable indexing for specific records
Next Topic: Oracle Text query with multiple contains performance
Goto Forum:
  


Current Time: Thu Mar 28 16:22:14 CDT 2024