Bill D is probably right. However, if there IS an index on this column, there probably shouldn't be one. You indicate that there is usually only 1 or 2 unique values in that field. An index would be adding way too much overhead to this table and probably make searching even slower.
Karen > Dan, > > Is there an index on idtrans? If so, > > > PACK INDEX FOR armbatch > > > (You can do this in multiuser mode) > > > Then try again. > > > If you have a broken index, that could explain the no rows found when > there's an ORDER BY. > > > Bill >
