如何优化这条sql语句呢?

select * from declarebill  where ModyfyTime like "%2008-02-22%" and EnterpriseType='外商投资企业' and Single_Audit='1' and billmode='02' or  EnterpriseType='中外合资企业' and ModyfyTime like "%2008-02-22%" and Single_Audit='1' and billmode='02'

我想EnterpriseType字段中的'外商投资企业'和'中外合资企业' 都拥有这个条件ModyfyTime like "%2008-02-22%" and Single_Audit='1' and billmode='02'
应该如何优化呢?我现在写的太长啦!

评论

2 楼 kevin226242 2008-03-03  

select * from declarebill where  ModyfyTime like "%2008-02-22%"
and EnterpriseType in('外商投资企业','中外合资企业') and Single_Audit='1' and billmode='02'

1 楼 mice123 2008-03-02  

tuning sql需要知道相关表的索引

ModyfyTime like "%2008-02-22%"
字段类型时间?varchar?