oj-sql

题目

SQL121 创建索引

思路

  1. create index;
  2. unique;
  3. fulltext index;

solution

create index

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