We have three tables which have a similar single valued symbolic field with a relational index which writes their record keys to different MVed fields in records of a fourth table which in turn has a btree index on part of its key for quick access.
We have found that sometimes entries get missed from these indexes.
Is this a reliable set of indexes to use, or is there known problems with this structure?