{"capability":{"Key":"covering-indexes-for-b-trees-include","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Covering Indexes for B-trees (INCLUDE)","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Covering Indexes for B-trees (INCLUDE)","NameLocale":"en","GroupKey":"indexing-constraints","GroupName":"Indexing \u0026 Constraints","GroupLocale":"en","Ordinal":4,"GroupOrder":2,"Facts":{"feature":{"description":"Allows additional columns to be included in as \"non-key\" columns in an index, and if requirements are met, can return data from these columns in an index-only scan.\r\n\r\nFore more information, please see the documentation on [Index-Only Scans \u0026 Covering Indexes](https://www.postgresql.org/docs/current/indexes-index-only-scans.html).","name":"Covering Indexes for B-trees (INCLUDE)","versions":{"11":"Yes"}},"group":"Indexing \u0026 Constraints","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"11","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"12","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},{"Version":"8.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"8.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.0","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.1","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.2","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.3","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.4","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.5","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"9.6","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"}],"Texts":[{"Locale":"en","Title":"Covering Indexes for B-trees (INCLUDE)","BodyHTML":"\u003cp\u003eAllows additional columns to be included in as \u0026#34;non-key\u0026#34; columns in an index, and if requirements are met, can return data from these columns in an index-only scan.\u003c/p\u003e\n\u003cp\u003eFore more information, please see the documentation on \u003ca href=\"https://www.postgresql.org/docs/current/indexes-index-only-scans.html\" rel=\"nofollow\"\u003eIndex-Only Scans \u0026amp; Covering Indexes\u003c/a\u003e.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"f76684bc501a8d276ed8ebaa5bca36bc11e243d3d9f500a315a6b8840953e538","Payload":{"description":"Allows additional columns to be included in as \"non-key\" columns in an index, and if requirements are met, can return data from these columns in an index-only scan.\r\n\r\nFore more information, please see the documentation on [Index-Only Scans \u0026 Covering Indexes](https://www.postgresql.org/docs/current/indexes-index-only-scans.html).","name":"Covering Indexes for B-trees (INCLUDE)","versions":{"11":"Yes"}}},{"Locale":"zh-Hans","Title":"B-树 的覆盖索引 (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":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"1aaf11594ca4ddb52d8f37cc8aed0180f677bb8fc6ea19e392234aa7154c7d2f","Payload":{"description":"允许将额外的列作为\"非键\"列包含在索引中，如果满足条件，可以在仅索引扫描中返回这些列的数据。\n\n更多信息请参阅 [仅索引扫描与覆盖索引](https://www.postgresql.org/docs/current/indexes-index-only-scans.html) 文档。","name":"B-树 的覆盖索引 (INCLUDE)"}}],"GroupTitles":{"en":"Indexing \u0026 Constraints","zh-Hans":"索引和约束"},"LegacyIDs":["313"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"11","Supported":true,"Original":"Yes"},"selected_version":"18"}