写了一个查询sql
SELECT h.n_jpkhid,h.v_khmc,h.v_khzw,h.v_khsr,h.v_dz,h.v_lxdh
FROM t_jp_jpkhb e,t_jp_jpdjb h
WHERE e.n_zxbz=0 AND e.n_jpkhid=h.n_jpkhid AND h.n_zxbz=0 and (e.c_sjg=? or ? is null) AND (e.c_dsjg=? or ? is null) AND (e.c_cljg=? or ? is null) AND (e.n_jpgzid = ? or ? is null)
ORDER BY h.v_khmc
一共有几万条数据,查询很慢,怎么能让查询速度快点?
新手,谢谢各位!
SELECT h.n_jpkhid,h.v_khmc,h.v_khzw,h.v_khsr,h.v_dz,h.v_lxdh
FROM t_jp_jpkhb e,t_jp_jpdjb h
WHERE e.n_zxbz=0 AND e.n_jpkhid=h.n_jpkhid AND h.n_zxbz=0 and (e.c_sjg=? or ? is null) AND (e.c_dsjg=? or ? is null) AND (e.c_cljg=? or ? is null) AND (e.n_jpgzid = ? or ? is null)
ORDER BY h.v_khmc
一共有几万条数据,查询很慢,怎么能让查询速度快点?
新手,谢谢各位!
应该是
e.n_jpgzid = ? or e.n_jpgzid is null 吧,