Inconsistency can happen if there should be a SW or HW crash or transaction rollback.
Databases support many indexing schemes -- better to keep the index and data in the same resource manager.
True, but an index is a disposable data structure that can be recreated from scratch so long as the original data is available.
-- Tom Bradford - http://www.tbradford.org Developer - Apache Xindice (Native XML Database) Creator - Project Labrador (XML Object Broker)
