Lucene full-text index isn’t recovery safe, which mean, that if during index modification, ScimoreDB server exists unexpectedly, Lucene index might become corrupted? Luckily, the index can be re-indexed again from the source (linked DB table). The rebuild index procedure combines unlinking and linking again the full-text index. The following example will rebuild full-text index linked with “debate” table:

alter table debate
(
drop constraint debate_table_search,
add constraint debate_table_search freetext(postid,threadid,dateline,title,pagetext)
references debate_search(postid,threadid,dateline,title,pagetext)
)