ALTER TABLE phpsnmp.applications
ADD INDEX applications_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.interfaces
ADD INDEX interfaces_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.ipaddresses
ADD INDEX ipaddresses_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.ipnettomedias
ADD INDEX ipnettomedias_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.iproutes
ADD INDEX iproutes_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.processes
ADD INDEX processes_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.processors
ADD INDEX processors_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.storages
ADD INDEX storages_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.systems
ADD INDEX systems_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.tcpconns
ADD INDEX tcpconns_snap_id_device_id_idx (snap_id, device_id);
ALTER TABLE phpsnmp.udpconns
ADD INDEX udpconns_snap_id_device_id_idx (snap_id, device_id);
MySQL创建复合索引
最新推荐文章于 2024-06-06 10:09:27 发布