Re: vanilla index

Posted in 2005

Art S. Kagel — Tue, 31 May 2005 15:37:07 -0400 — source: Usenet: comp.databases.informix

Ray wrote: > Hi All, > > Does anyone know what non vanilla index and this message means? Thanks > in advance! Sounds like the index stat_loc_ix1 is not a B+Tree index but an RTREE, CopperEye, or other VII based index which oncheck -cD cannot crosscheck to verify that all rowids listed in the index are found in the table and vice-versa. Art S. Kagel > $ oncheck -cDI hoc:stat_loc> > Validating indexes for hoc:informix.stat_loc... > Index stat_loc_ix1 > Index fragment in DBspace dbidx01 > Index stat_loc_ix1: Non vanilla index. data > crosschecking not enabled > > TBLspace data check for hoc:informix.stat_loc >