另外一个问题,你这个建表SQL没发错的话,下面这两组索引不是重复了吗?
PRIMARY KEY (`alarm_id`,`start_time`) /*T![clustered_index] NONCLUSTERED */,
UNIQUE KEY `uniq_alarm_id` (`alarm_id`,`start_time`),
KEY `idx_start_time` (`start_time`),
KEY `idx_end_time` (`start_time`),
另外一个问题,你这个建表SQL没发错的话,下面这两组索引不是重复了吗?
PRIMARY KEY (`alarm_id`,`start_time`) /*T![clustered_index] NONCLUSTERED */,
UNIQUE KEY `uniq_alarm_id` (`alarm_id`,`start_time`),
KEY `idx_start_time` (`start_time`),
KEY `idx_end_time` (`start_time`),