[code="java"]select t.* from tbl_part_00 t where 1 = 1 and sm_Id in ('1023352756','1023343286');[/code]
这句sql怎么优化
建立sm_Id字段上建立索引后就没必要优化了
select t.* from tbl_part_00 t where 1 = 1 and (sm_Id='1023352756' or sm_Id='1023343286');
select t.* from tbl_part_00 t where sm_Id = '1023352756' union all select t.* from tbl_part_00 t where sm_Id ='1023343286';