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);