{"capability":{"Key":"create-statistics-most-common-values-mcv-statistics","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"CREATE STATISTICS - most-common values (MCV) statistics","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"CREATE STATISTICS - most-common values (MCV) statistics","NameLocale":"en","GroupKey":"performance","GroupName":"Performance","GroupLocale":"en","Ordinal":7,"GroupOrder":5,"Facts":{"feature":{"description":"CREATE STATISTICS  can collection statistics on the most common value, which can improve optimizations for columns that contain nonuniform distributions.","name":"CREATE STATISTICS - most-common values (MCV) statistics","versions":{"12":"Yes"}},"group":"Performance","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":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","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":"CREATE STATISTICS - most-common values (MCV) statistics","BodyHTML":"\u003cp\u003eCREATE STATISTICS  can collection statistics on the most common value, which can improve optimizations for columns that contain nonuniform distributions.\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"13186f49424639a3ea429fc70c2ce7dffe78ce0c5584e403fc9d66d17e5d7e4a","Payload":{"description":"CREATE STATISTICS  can collection statistics on the most common value, which can improve optimizations for columns that contain nonuniform distributions.","name":"CREATE STATISTICS - most-common values (MCV) statistics","versions":{"12":"Yes"}}},{"Locale":"zh-Hans","Title":"CREATE STATISTICS - 高频值 (MCV) 统计信息","BodyHTML":"\u003cp\u003eCREATE STATISTICS 可以收集高频值的统计信息，从而改善对包含非均匀分布的列的优化。\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"4b68e50a4897f8605148c7a877ff9fb597e9dc49568b6a08f3164355f863f303","Payload":{"description":"CREATE STATISTICS 可以收集高频值的统计信息，从而改善对包含非均匀分布的列的优化。","name":"CREATE STATISTICS - 高频值 (MCV) 统计信息"}}],"GroupTitles":{"en":"Performance","zh-Hans":"性能"},"LegacyIDs":["318"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"12","Supported":true,"Original":"Yes"},"selected_version":"18"}