Closed alphashuro closed 4 years ago
This query is run during remote_sync, but does not use the index on status due to the !=. Using a combination of > and < does however use the index, and running an EXPLAIN on the query indicates that it will run much faster after this change.
remote_sync
index
status
!=
EXPLAIN
This query is run during
remote_sync, but does not use theindexonstatusdue to the!=. Using a combination of > and < does however use the index, and running anEXPLAINon the query indicates that it will run much faster after this change.