Updating index information without recreating the index AND Problem executing ctx procedures (merged [message #270431] |
Wed, 26 September 2007 21:34 |
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..??
|
|
|