Covering index if all requested columns exists in an index, not all rows.
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 617
- Forks
- 724
- Avg merge
- 2d 10h
- Merged PRs (30d)
- 223
Description
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
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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Open the stable explain-indexes documentation page named in the issue and locate the covering index explanation. Update the wording from “all rows” to “all requested columns,” clarify the optimization as requested, and verify that the surrounding IndexLookup examples still match the explanation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, documentation
- Issue type
- Documentation
- Difficulty
- 1/5
- Estimated time
- Under an hour
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 55/100