帮我优化这段sql：SELECT asewo.code_s as code,asewo.order_type_s as orderType,asewo.equipment_name_s as equipmentName,asewo.executor_s as executor, asewo.plan_start_time_T as planStartTime,asewo.plan_finish_time_T as planFinishTime,asewo.tpm_key_s as tpmKey,asewo.shop_s as shop, asewo.line_S as line,asewo.actual_start_time_t as startTime,asewo.actual_finish_time_t as finishTime,asewo.executor_account_s as executorAccounts, asewo.source_type_s as sourceType,asewo.SOURCE_ORDER_S as sourceOrder,asewo.CREATION_TIME as creationTime FROM AT_AS_EM_Work_Order asewo WHERE to_char(asewo.plan_start_time_T,'yyyy_mm-dd hh24:mi') <= to_char(plan_finish_time_T,'yyyy_mm_dd hh24:mi') AND asewo.ORDER_STATUS_S='创建' AND asewo.executor_s='H007063' AND asewo.EQUIPMENT_NAME_S like '%机%' GROUP BY asewo.shop_s, asewo.line_S

可以尝试以下几种优化方式：

1. 建立索引：为了让查询更快速，可以在 `AT_AS_EM_Work_Order` 表中建立索引，包括 `plan_start_time_T`、`plan_finish_time_T`、`ORDER_STATUS_S`、`executor_s` 和 `EQUIPMENT_NAME_S` 字段。

2. 修改查询条件：可以将日期格式化的操作移动到查询条件外部，在查询条件内直接比较日期类型的字段。同时可以将 `GROUP BY` 字段减少到仅保留 `shop_s` 字段，这样可以让查询更快速。

修改后的 SQL 可以是这样的：

SELECT asewo.code_s as code,
       asewo.order_type_s as orderType,
       asewo.equipment_name_s as equipmentName,
       asewo.executor_s as executor,
       asewo.plan_start_time_T as planStartTime,
       asewo.plan_finish_time_T as planFinishTime,
       asewo.tpm_key_s as tpmKey,
       asewo.shop_s as shop,
       asewo.line_S as line,
       asewo.actual_start_time_t as startTime,
       asewo.actual_finish_time_t as finishTime,
       asewo.executor_account_s as executorAccounts,
       asewo.source_type_s as sourceType,
       asewo.SOURCE_ORDER_S as sourceOrder,
       asewo.CREATION_TIME as creationTime
FROM AT_AS_EM_Work_Order asewo
WHERE asewo.plan_start_time_T <= asewo.plan_finish_time_T
  AND asewo.ORDER_STATUS_S = '创建'
  AND asewo.executor_s = 'H007063'
  AND asewo.EQUIPMENT_NAME_S LIKE '%机%'
GROUP BY asewo.shop_s

3. 分批查询：如果数据量非常大，可以将查询分批进行，每次查询一部分数据，然后将结果合并。这样可以减少单次查询的数据量，从而提高查询效率。