CREATE INDEX idx_b_del_flag_id_status_execution_time
|
ON t_task_detail (del_flag, id, status, execution_time);
|
|
CREATE INDEX idx_a_task_detail_id ON t_task_detail_vehicles (task_detail_id);
|
|
CREATE INDEX idx_a_patrol_task_id ON t_task_detail_vehicles (patrol_task_id);
|
|
CREATE INDEX idx_d_task_detail_vehicles_id ON t_task_detail_vehicles_channel (task_detail_vehicles_id);
|
|
CREATE INDEX idx_d_artificial_user_id ON t_task_detail_vehicles_channel (artificial_user_id);
|