But SQLite has the SKIP-SCAN optimization, so recreating a 1-column index on the 2nd column of an existing index may not always be the best option, it depends on the cardinality of the 1st column of that 2-column index.
But SQLite has the SKIP-SCAN optimization, so recreating a 1-column index on the 2nd column of an existing index may not always be the best option, it depends on the cardinality of the 1st column of that 2-column index.