分开两条sql写:
select * from user where userid=1
select * from user where age = 18
//使用union all
select * from user where userid=1
unionall
select * from user where age = 18
4.优化limit分页
//方案一 :返回上次查询的最大记录(偏移量)
select id,name from employee where id>10000 limit 10.
//方案二:orderby + 索引
select id,name from employee order by id limit 10000,10
5、优化你的like语句
select userId,name from user where userId like'123%';
6、使用where条件限定要查询的数据,避免返回多余的行
Long userId = sqlMap.queryObject("select userId from user where userId='userId' and isVip='1'")boolean isVip = userId!=null;
7.尽量避免在索引列上使用mysql的内置函数
explain select userId,loginTime from loginuser where loginTime >= Date_ADD(NOW(),INTERVAL - 7DAY);