SQL122. 删除索引
描述
示例1
输入:
drop table if exists examination_info; CREATE TABLE IF NOT EXISTS examination_info ( id int PRIMARY KEY AUTO_INCREMENT COMMENT '自增ID', exam_id int COMMENT '试卷ID', tag varchar(32) COMMENT '类别标签', difficulty varchar(8) COMMENT '难度', duration int NOT NULL COMMENT '时长(分钟数)', release_time datetime COMMENT '发布时间' )CHARACTER SET utf8 COLLATE utf8_bin; CREATE INDEX idx_duration ON examination_info(duration); CREATE UNIQUE INDEX uniq_idx_exam_id ON examination_info(exam_id); ALTER TABLE examination_info ADD FULLTEXT full_idx_tag(tag);
输出:
examination_info|0|PRIMARY|1|id|A|0|None|None||BTREE|||YES|None examination_info|1|idx_duration|1|duration|A|0|None|None||BTREE|||YES|None
Mysql 解法, 执行用时: 36ms, 内存消耗: 6216KB, 提交时间: 2022-01-24
drop index uniq_idx_exam_id on examination_info; drop index full_idx_tag on examination_info
Mysql 解法, 执行用时: 36ms, 内存消耗: 6244KB, 提交时间: 2021-12-17
alter table examination_info drop index uniq_idx_exam_id, drop index full_idx_tag
Mysql 解法, 执行用时: 36ms, 内存消耗: 6288KB, 提交时间: 2021-12-09
# alter table examination_info drop index uniq_idx_exam; # alter table examination_info drop index full_dix_tag; drop index uniq_idx_exam_id on examination_info; drop index full_idx_tag on examination_info;
Mysql 解法, 执行用时: 36ms, 内存消耗: 6420KB, 提交时间: 2021-12-07
alter table examination_info drop INDEX uniq_idx_exam_id; alter table examination_info drop index full_idx_tag;
Mysql 解法, 执行用时: 37ms, 内存消耗: 6168KB, 提交时间: 2021-12-09
ALTER TABLE examination_info DROP index uniq_idx_exam_id, DROP INDEX full_idx_tag