问答1：哪个Sql更快

假设订单有三种状态：0已下单，1已支付，2已完成。业务需求，查询未完成的订单，哪个SQL更快呢？

• select * from order where status!=2

• select * from order where status=0 or status=1

• select * from order where status IN (0,1)

• select * from order where status=0

  union

  select * from order where stauts=1