I've debugged an odd problem - right after doing some programmatic Alter Tables on a certain table, the indexes are all fouled up, even when I close all indexes beforehand, and when I'm not altering a field involved in an index.
I get bizarre record order when I SET ORDER right after this...I have to either close the table and reopen it, or do a DELETE TAG and fresh INDEX ON to get indexes back working correctly...weird?
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.