oracle in VS or效率

select * from test where status in ('01', '02', '03', '111');

select * from test where status = '01' or status = '02' or status = '03' or status = '111';

in查询比or要高10倍的效率

 

转载于:https://www.cnblogs.com/imaikce/p/6074028.html