In AOT, when I create a new index, and I want the key columns in a specific order, I understand I have to add them in the reverse order. ie if I want key column order col1, col2, col3, then when adding a new column to the index, I have to add columns in reverse order ie: col3, col2, col1.
However if I have to edit an existing index and add a new key column, AOT adds the column to the front of the key. If I want this new key column as the last column, or in the middle, how does one go about doing that? Do I need to create a new index in AOT, then drop the existing index?
Select field in the index and press Alt+Up or Alt+Down to move it up or down.
See Shortcut Keys: AOT for more.