大佬,这条sql该如何优化,索引基本都创建遍了
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
1