createindex.sql

来自「该票务系统包括的功能有网上订票、历史订阅纪录查询、近期上映影片推荐和查询和统计报」· SQL 代码 · 共 7 行

create index f_index on film (film_name);
create index country_index on  film (country);
create index Sec_index on show (film_id);
create index tic_index on ticket (section,sold);
create index rec_index on bookRecord(customer_id);
create index rid_index on show(room_num);