-- 空载具按排找位及组盘存在性判断索引（执行前请确认同名索引尚未创建）。
CREATE INDEX idx_struct_empty_vehicle_row
    ON wms_structattr
       (deleted, is_used, stor_id, sect_id, block_num, row_num, layer_num,
        lock_type, storagevehicle_code, col_num);

CREATE INDEX idx_group_plate_vehicle_deleted
    ON wms_group_plate (vehicle_code, deleted);