I seem to recall reading a while back in the documentation that metamorph inverted indexes do not automatically update as data in the underlying table is changed, but now I can't find that documentation page. Is this true? If it is true, is this a default behavior that can be overridden. That is, is there any way to create a MMI index that *does* automatically update?
The index is always updated, but not optimized as the data changes. You can configure chkind to control how often the index is optimized, or manually choose when to optimize by reissuing the create index statement.
So to clarify, will chkind optimize the index once one or both of the thresholds in SYSMETAINDEX are met? Or does chkind somehow just send a notification that this needs to be done? Also, how would I run chkind in the background (as a service?) on Windows server?