Index Column Selection (Create Index)

Use this panel to select the columns that comprise the index.

Note:

Each time a column is selected using S, it is assigned an order one greater than the maximum order used so far.

If the column currently containing the highest order number is deselected, the maximum order is decremented (otherwise unchanged).

Because of the previous point and the ability of the user to enter an arbitrary number, gaps can occur in the order. However, any such gaps are ignored when the SQL is built.

Related references

Create Index: Column Selection panel