You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
TiDB supports the covering index optimization. If all rows can be retrieved from an index, TiDB will skip the second step that is usually required in an IndexLookup. Consider the following two examples:
to
TiDB supports the covering index optimization. If all requested columns can be retrieved from an index, TiDB will skip the second step that is usually required in an IndexLookup. Consider the following two examples:
Since a covering index means that all columns in the index (including possible Primary Key columns added implicitly, to find the full table row), it should be columns and not rows, perhaps with a bit more explaining why this is a very good optimization for using indexes.
The text was updated successfully, but these errors were encountered:
Error Report
Please answer the following questions before submitting your issue. Thanks!
What is the URL/path of the document related to this issue?
https://docs.pingcap.com/tidb/stable/explain-indexes
How would you like to improve it?
From
to
Since a covering index means that all columns in the index (including possible Primary Key columns added implicitly, to find the full table row), it should be
columns
and notrows
, perhaps with a bit more explaining why this is a very good optimization for using indexes.The text was updated successfully, but these errors were encountered: