First, include in the index all the columns in the WHERE clause, so that index screening can be used to reject unqualified rows from the result set.
首先,在索引中包括WHERE子句中的所有列,这样,就可以使用索引形成的屏蔽来拒绝结果集中不合格的行。
First, include in the index all the columns in the WHERE clause, so that index screening can be used to reject unqualified rows from the result set.
首先,在索引中包括WHERE子句中的所有列,这样,就可以使用索引形成的屏蔽来拒绝结果集中不合格的行。
应用推荐