What is the difference between incremental indexing using chkind and execution of a createindex statement without dropping the existing index? As I understand it, if a createindex statement is issued, indexes are updated with all changed records - sort of like how chkind does the index update incrementally. Please correct me if this assumption is erroneous.
The difference is that chkind will periodically check the table to see if the index needs updating based on the values in SYSMETAINDEX, whereas the "CREATE INDEX" just updates the index. The actual update is the same, just whether it is triggered automatically or manually.
