So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.

因此要找到满足select语句中谓词的行，这个优化器必须将主表中的所有行上锁、读取它们的值并与谓词中提供的值进行比较。

youdao

So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.

因此要找到满足select语句中谓词的行，这个优化器必须将主表中的所有行上锁、读取它们的值并与谓词中提供的值进行比较。

youdao