你的位置:首页 > 数据库

[数据库]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倍的效率