SQLite Forum

Is there a way to optimize this UPDATE command to run faster?
Create a unique index on the combination of columns in the join (snapshot_id, object_id) in that order so that the processing can find all the rows which have snapshot == 5 and use the (3, object_id) to find the row to update.  Without that index one or the other (or both) devolve into a table scans.