B-tree 的覆盖索引 (INCLUDE)
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
No translation of this description is recorded. The original Chinese description is shown. The source label is retained in Chinese; no translated label is recorded.
索引和约束
Description
允许将额外的列作为"非键"列包含在索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。
更多信息请参阅 仅索引扫描与覆盖索引 文档。
Selected version: PostgreSQL 18
No
Compare versions
Original documentation links
Related source snapshot entry · The original source supplies this relationship; each matrix retains its own states.
Complete source facts and provenance
legacy · center · 0b211d2086c0ecb083dcf75e1d1752a5ddbfd9dd60de4b008494a3bd610eb1b8
{
"Key": "313",
"SourceKind": "legacy",
"SourceDatabase": "center",
"SourceTable": "featurematrix_feature",
"SourceKey": "313",
"SourceHash": "0b211d2086c0ecb083dcf75e1d1752a5ddbfd9dd60de4b008494a3bd610eb1b8",
"Name": "B-tree 的覆盖索引 (INCLUDE)",
"NameLocale": "zh-Hans",
"GroupKey": "13",
"GroupName": "索引和约束",
"GroupLocale": "zh-Hans",
"Ordinal": 0,
"GroupOrder": 4,
"Facts": {
"featuredescription": "允许将额外的列作为\"非键\"列包含在索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\n\n更多信息请参阅 [仅索引扫描与覆盖索引](https://www.postgresql.org/docs/current/indexes-index-only-scans.html) 文档。",
"featurename": "B-tree 的覆盖索引 (INCLUDE)",
"group_id": 13,
"id": 313,
"v10": 0,
"v11": 1,
"v12": 1,
"v13": 1,
"v14": 0,
"v15": 0,
"v16": 0,
"v17": 0,
"v18": 0,
"v74": 0,
"v80": 0,
"v81": 0,
"v82": 0,
"v83": 0,
"v84": 0,
"v90": 0,
"v91": 0,
"v92": 0,
"v93": 0,
"v94": 0,
"v95": 0,
"v96": 0
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "legacy-database:v10",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "11",
"State": "yes",
"EvidenceKind": "legacy-database:v11",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "12",
"State": "yes",
"EvidenceKind": "legacy-database:v12",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "13",
"State": "yes",
"EvidenceKind": "legacy-database:v13",
"TransitionVersion": "",
"Supported": true,
"Original": 1
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "legacy-database:v14",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "15",
"State": "no",
"EvidenceKind": "legacy-database:v15",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "16",
"State": "no",
"EvidenceKind": "legacy-database:v16",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "17",
"State": "no",
"EvidenceKind": "legacy-database:v17",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "18",
"State": "no",
"EvidenceKind": "legacy-database:v18",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "7.4",
"State": "no",
"EvidenceKind": "legacy-database:v74",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.0",
"State": "no",
"EvidenceKind": "legacy-database:v80",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "legacy-database:v81",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "legacy-database:v82",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "legacy-database:v83",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "legacy-database:v84",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "legacy-database:v90",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "legacy-database:v91",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "legacy-database:v92",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "legacy-database:v93",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "legacy-database:v94",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "legacy-database:v95",
"TransitionVersion": "",
"Supported": false,
"Original": 0
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "legacy-database:v96",
"TransitionVersion": "",
"Supported": false,
"Original": 0
}
],
"Texts": [
{
"Locale": "zh-Hans",
"Title": "B-tree 的覆盖索引 (INCLUDE)",
"BodyHTML": "\u003cp\u003e允许将额外的列作为\u0026#34;非键\u0026#34;列包含在索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\u003c/p\u003e\n\u003cp\u003e更多信息请参阅 \u003ca href=\"https://www.postgresql.org/docs/current/indexes-index-only-scans.html\" rel=\"nofollow\"\u003e仅索引扫描与覆盖索引\u003c/a\u003e 文档。\u003c/p\u003e\n",
"SourceHash": "0b211d2086c0ecb083dcf75e1d1752a5ddbfd9dd60de4b008494a3bd610eb1b8",
"ContentHash": "c10340e5fc445ca493a198a39eff17aa288d38f343d37c04e68017713d8a5495",
"Payload": {
"description": "允许将额外的列作为\"非键\"列包含在索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\n\n更多信息请参阅 [仅索引扫描与覆盖索引](https://www.postgresql.org/docs/current/indexes-index-only-scans.html) 文档。",
"name": "B-tree 的覆盖索引 (INCLUDE)"
}
}
],
"GroupTitles": {
"zh-Hans": "索引和约束"
},
"RelatedKey": "covering-indexes-for-b-trees-include"
}