index.sql

来自「linux下c 编写的 某项目代理服务端部分的代码。其中包括网络通信」· SQL 代码 · 共 20 行

drop index idx_site_name_time ;
create unique index idx_site_name_time 
	on alarm(alarm_site_no,alarm_name_no)
   tablespace omcr_index;


drop index idx_alarm_site_name_time ;
create unique index idx_alarm_site_name_time 
	on alarm_env(alarm_time desc,alarm_site_no,alarm_name_no)
   tablespace omcr_index;

drop index idx_para_site_name;
create unique index idx_para_site_name
	on para_alarm_site_no(name)
   tablespace omcr_index;

--drop index idx_alarm_site_name_time ;
--create unique index idx_alarm_site_name_time 
--	on alarm_env(alarm_time desc,city_no,agency_no,alarm_site_no,alarm_name_no)
--   tablespace omcr_index;