云数据库 TaurusDB-Statement Outline:Statement Outline表介绍

时间：2025-01-26 10:50:56

云数据库 TaurusDB

Statement Outline表介绍

TaurusDB内置了一个系统表（outline）保存Hint，系统启动时会自动创建该表，无需您手动创建。创建表的SQL语句如下：

CREATE TABLE `mysql`.`outline` (  `Id` bigint(20) NOT NULL AUTO_INCREMENT,  `Schema_name` varchar(64) COLLATE utf8_bin DEFAULT NULL,  `Digest` varchar(64) COLLATE utf8_bin NOT NULL,  `Digest_text` longtext COLLATE utf8_bin,  `Type` enum('IGNORE INDEX','USE INDEX','FORCE INDEX','OPTIMIZER') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,  `Scope` enum('','FOR JOIN','FOR ORDER BY','FOR GROUP BY') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '',  `State` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Y',  `Position` bigint(20) NOT NULL,  `Hint` text COLLATE utf8_bin NOT NULL,  PRIMARY KEY (`Id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0 COMMENT='Statement outline'

上一篇：云数据库 TaurusDB-多租户管理与资源隔离:用户管理

下一篇：云数据库 TaurusDB-HASH-HASH:语法