请问如何加速查询的速度?
我用jsp在informix数据库里面查询纪录,当复杂查询很大的几个表的时候:
String strSql="select issno,serino,m06_name,m02_date from barcode,miss,mcust where m02_date>="+"'"+strDate1+"'"+" and m02_date<="+"'"+strDate2+"'";
strSql=strSql+ " and miss.m02_co='M'";
strSql=strSql+ " and miss.m02_iss_no = barcode.issno";
strSql=strSql+ " and mcust.m06_bill_to = miss.m02_bill_to";
strSql=strSql+ " and barcode.issno like '%"+strIssNo+"%'";
strSql=strSql+ " and barcode.serino like '%"+strSerino+"%'";
strSql=strSql+ " ORDER BY barcode.issno,barcode.serino";
很慢,怎么解决?