数据仓库服务 GaussDB(DWS)-DELAY_KEY_WRITE

时间：2025-02-12 15:05:07

DELAY_KEY_WRITE

DELAY_KEY_WRITE只对MyISAM引擎表有作用，根据DELAY_KEY_WRITE的值来延迟更新直至表关闭。 GaussDB (DWS)不支持该属性修改表定义信息，DSC迁移时会将该属性删除。

输入示例

     
          CREATE TABLE `public`.`runoob_tbl_test`(    `runoob_id` VARCHAR(30),    `runoob_title` VARCHAR(100) NOT NULL,    `runoob_author` VARCHAR(40) NOT NULL,    `submission_date` VARCHAR(30)) ENGINE=MyISAM, DELAY_KEY_WRITE=0;ALTER TABLE `public`.`runoob_tbl_test6` DELAY_KEY_WRITE=1;

输出示例

     
          CREATE TABLE "public"."runoob_tbl_test"(  "runoob_id" VARCHAR(120),  "runoob_title" VARCHAR(400) NOT NULL,  "runoob_author" VARCHAR(160) NOT NULL,  "submission_date" VARCHAR(120))  WITH ( ORIENTATION = ROW, COMPRESSION = NO )  NOCOMPRESS  DISTRIBUTE BY HASH ("runoob_id");