{"capability":{"Key":"reduced-lock-levels-for-alter-table-commands","SourceKind":"yaml","SourceDatabase":"center","SourceTable":"featurematrix.yaml","SourceKey":"Reduced lock levels for ALTER TABLE commands","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","Name":"Reduced lock levels for ALTER TABLE commands","NameLocale":"en","GroupKey":"performance","GroupName":"Performance","GroupLocale":"en","Ordinal":42,"GroupOrder":5,"Facts":{"feature":{"description":"The following commands now have reduced lock levels for reduced lock contention:\r\n\r\nVALIDATE CONSTRAINT\r\n\r\nCLUSTER ON\r\nSET WITHOUT CLUSTER\r\n\r\nALTER COLUMN SET STATISTICS\r\nALTER COLUMN SET ()\r\nALTER COLUMN RESET ()","name":"Reduced lock levels for ALTER TABLE commands","versions":{"9.4":"Yes"}},"group":"Performance","versions":{"max":18,"min":8.1}},"Cells":[{"Version":"10","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"11","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"12","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"13","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"14","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"15","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"16","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"17","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","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":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"9.5","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},{"Version":"9.6","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"}],"Texts":[{"Locale":"en","Title":"Reduced lock levels for ALTER TABLE commands","BodyHTML":"\u003cp\u003eThe following commands now have reduced lock levels for reduced lock contention:\u003c/p\u003e\n\u003cp\u003eVALIDATE CONSTRAINT\u003c/p\u003e\n\u003cp\u003eCLUSTER ON\nSET WITHOUT CLUSTER\u003c/p\u003e\n\u003cp\u003eALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()\u003c/p\u003e\n","SourceHash":"1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd","ContentHash":"2ac3c0ba433c8227adde1d6623f4a31a3f42c11714a41ea06ce75eed5dbab72e","Payload":{"description":"The following commands now have reduced lock levels for reduced lock contention:\r\n\r\nVALIDATE CONSTRAINT\r\n\r\nCLUSTER ON\r\nSET WITHOUT CLUSTER\r\n\r\nALTER COLUMN SET STATISTICS\r\nALTER COLUMN SET ()\r\nALTER COLUMN RESET ()","name":"Reduced lock levels for ALTER TABLE commands","versions":{"9.4":"Yes"}}},{"Locale":"zh-Hans","Title":"ALTER TABLE 命令的锁定级别降低","BodyHTML":"\u003cp\u003e以下命令现在具有更低的锁定级别以减少锁竞争：\u003c/p\u003e\n\u003cp\u003eVALIDATE CONSTRAINT\u003c/p\u003e\n\u003cp\u003eCLUSTER ON\nSET WITHOUT CLUSTER\u003c/p\u003e\n\u003cp\u003eALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()\u003c/p\u003e\n","SourceHash":"071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50","ContentHash":"daeb107dfaeddbc2b779f9b8dd3da94e19443898dcd48aee27c684a7f911f50c","Payload":{"description":"以下命令现在具有更低的锁定级别以减少锁竞争：\n\nVALIDATE CONSTRAINT\n\nCLUSTER ON\nSET WITHOUT CLUSTER\n\nALTER COLUMN SET STATISTICS\nALTER COLUMN SET ()\nALTER COLUMN RESET ()","name":"ALTER TABLE 命令的锁定级别降低"}}],"GroupTitles":{"en":"Performance","zh-Hans":"性能"},"LegacyIDs":["258"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"9.4","Supported":true,"Original":"Yes"},"selected_version":"18"}