If USE KEYS you can skip the index. But still keep the WHERE clause so that if the document doesn’t qualify no update is done. If you remove WHERE clause it will update same document again if not qualified.
If USE KEYS you can skip the index. But still keep the WHERE clause so that if the document doesn’t qualify no update is done. If you remove WHERE clause it will update same document again if not qualified.