There isn't an index on that column, but I did add where 1=1 in the
command and it works fine now. Never needed that before. Strange
things going on here lately.
At 04:57 PM 2/15/2010, you wrote:
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
