Just a thought: is the Alter Table changing indexed fields? Is there an order set when you Alter?

>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?