Re: Bug ? No rows returned from a view

Martin Brassard wrote: > In the folowing problem, it seems that Informix doesn't return the same > data depending of the query plan it uses. > > The query plan perform an index search on the master table for the first > case, but a sequential scan in the second (this is ok because the > interval covers almost all the table). Sounds to me like the index on the master table is corrupted. If you just try a basic query against the master table, which requires the index, do you get the right results back? I'd recommend running oncheck against your table, or just drop and re-create the index. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on Plain M&M's