大佬，这条sql该如何优化，索引基本都创建遍了

level 1

admit等丫楼主

select id from T_TRAINORDER t_order with(nolock)
where t_order.C_DEAL_STATUS = 0
and t_order.C_DEAL_RESULT in (0,1)
and t_order.C_STATE12306 = 6
AND t_order.C_ORDERSTATUS != 2
AND t_order.C_ORDERSTATUS != 3
AND t_order.C_ORDERSTATUS != 102
AND t_order.C_ORDERSTATUS != 103
and t_order.C_CREATETIME >= dateadd(MINUTE, -30, GETDATE())

2021年07月29日 13点07分 1

level 8

咸鱼初号机💤

select id from T_TRAINORDER t_order with(nolock)
where t_order.C_DEAL_STATUS = 0
and t_order.C_DEAL_RESULT in (0,1)
and t_order.C_STATE12306 = 6
AND t_order.C_ORDERSTATUS not in (2,3,102,103)
and t_order.C_CREATETIME >= dateadd(MINUTE, -30, GETDATE())

2021年08月02日 02点08分 2