帮我优化这段SQL：select count(*) as F_Add_Number from LAB_Order_Base base where 1=1 and base.F_Status_Word < 10000 and base.F_Status_Word > 1020 and base.F_ECD_Node3 >= '2023-05-17 00:00:00' and base.F_ECD_Node3 <= '2023-05-23 23:59:59' and (select top 1 rec.F_Order_Workflow_RecordID from LAB_Order_Workflow_Record rec where rec.F_Flow_Type = '0' and rec.F_Operation_Type = 'S' and rec.F_Flow_Node_Code = '2011' and rec.F_Order_NO = base.F_Order_NO) is not null

可以尝试以下优化方式：

1. 尽量避免使用子查询，可以使用 JOIN 操作来替代。如：

select count(*) as F_Add_Number  
from LAB_Order_Base base 
join LAB_Order_Workflow_Record rec on rec.F_Order_NO = base.F_Order_NO 
where base.F_Status_Word < 10000 and base.F_Status_Word > 1020  
and base.F_ECD_Node3 >= '2023-05-17 00:00:00' and base.F_ECD_Node3 <= '2023-05-23 23:59:59'  
and rec.F_Flow_Type = '0' and rec.F_Operation_Type = 'S' and rec.F_Flow_Node_Code = '2011'

2. 确保表有索引，可以创建索引来加速查询。对于该 SQL 语句，可以考虑在 LAB_Order_Base 表上创建如下联合索引：

CREATE INDEX idx_order_base ON LAB_Order_Base (F_Status_Word, F_ECD_Node3, F_Order_NO);

3. 建议使用 BETWEEN 来代替 >= 和 <= 的组合，如：

base.F_ECD_Node3 BETWEEN '2023-05-17 00:00:00' AND '2023-05-23 23:59:59'