{"capability":{"Key":"skip-scan-on-multicolumn-b-tree-indexes","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Skip scan on multicolumn B-tree indexes","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Skip scan on multicolumn B-tree indexes","NameLocale":"en","GroupKey":"indexing-constraints","GroupName":"Indexing \u0026 Constraints","GroupLocale":"en","Ordinal":24,"GroupOrder":2,"Facts":{"feature":{"description":"Improve execution time for queries that omit an `=` condition on one or more prefix index columns.","name":"Skip scan on multicolumn B-tree indexes","versions":{"18":"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":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"12","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"13","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"14","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"15","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"16","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"17","State":"no","EvidenceKind":"yaml-default-no","TransitionVersion":"","Supported":false,"Original":"No"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"18","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":"Skip scan on multicolumn B-tree indexes","BodyHTML":"\u003cp\u003eImprove execution time for queries that omit an \u003ccode\u003e=\u003c/code\u003e condition on one or more prefix index columns.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"0a622beee67a8a3105b5fb137b5686fd99e958ff4c09f2316456376e37fddb9e","Payload":{"description":"Improve execution time for queries that omit an `=` condition on one or more prefix index columns.","name":"Skip scan on multicolumn B-tree indexes","versions":{"18":"Yes"}}},{"Locale":"zh-Hans","Title":"多列 B-树 索引上的跳跃扫描","BodyHTML":"\u003cp\u003e对于在一个或多个前导索引列上缺少 \u003ccode\u003e=\u003c/code\u003e 条件的查询，多列 B-树 索引现在可以使用跳跃扫描来改善执行时间。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"b338d4c80bf896eefc6e48f88e52c8dbc775cba538355a9a215bcfd12c6b07ba","Payload":{"description":"对于在一个或多个前导索引列上缺少 `=` 条件的查询，多列 B-树 索引现在可以使用跳跃扫描来改善执行时间。","name":"多列 B-树 索引上的跳跃扫描"}}],"GroupTitles":{"en":"Indexing \u0026 Constraints","zh-Hans":"索引和约束"}},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"18","Supported":true,"Original":"Yes"},"selected_version":"18"}