I am having trouble optimizing for the insertion of new list elements.

For a list with an index, when I insert it and check the SQL executed, it is in two parts.

INSERT INTO ... VALUE (...) <-- This doesn't set the INDEX_ORDER

and

UPDATE ID, INDEX_ORDER where ID = ?

I am just wondering if it is possible to also have the INDEX_ORDER inserted in the INSERT statement.

Thank you very much.