题解 | #创建索引#
创建索引
https://www.nowcoder.com/practice/f2ea9ccf33c740d58576608940981807
CREATE INDEX idx_duration ON examination_info (duration); CREATE unique INDEX uniq_idx_exam_id ON examination_info (exam_id); #CREATE fulltext INDEX full_idx_tag ON examination_info (tag); ALTER TABLE examination_info add fulltext INDEX full_idx_tag(tag);