I would guess it's often useful in these conditions: 1. It is an `INSERT INTO SELECT FROM` (i.e. the target table is likely empty) 2. The target table is `WITHOUT ROWID` or it has a related index 3. The `SELECT FROM` is ordered in the same way as the table or index Regardless of what you decide regarding implementation (or deciding not to), thank you for answering my questions on this topic.